Hello everyone i have a table that contains text, the table name is “top_issue”
Existing data:
| Upload Date | Created At | issue |
|---|---|---|
| 2024-07-01 | 2024-07-01 | the files are bugged |
| 2024-07-01 | 2024-07-01 | Issue 1 |
| 2024-07-02 | 2024-07-02 | Issue 2 |
| 2024-07-02 | 2024-07-02 | Issue 3 |
| 2024-07-03 | 2024-07-03 | Issue 4 |
| 2024-07-03 | 2024-07-03 | Issue 5 |
| 2024-07-03 | 2024-07-03 | Issue 6 |
| 2024-07-04 | 2024-07-04 | Issue 7 |
| 2024-07-04 | 2024-07-04 | Issue 8 |
| 2024-07-04 | 2024-07-04 | Issue 9 |
| 2024-07-04 | 2024-07-04 | Issue 10 |
I want to show when it’s on 4th, 5th July, and onwards appears like this
| Upload Date | Created At | issue |
|---|---|---|
| 2024-07-04 | 2024-07-04 | Issue 7 |
| 2024-07-04 | 2024-07-04 | Issue 8 |
| 2024-07-04 | 2024-07-04 | Issue 9 |
| 2024-07-04 | 2024-07-04 | Issue 10 |
If there’s a new data upload on 10th July it will appear like this:
| Upload Date | Created At | issue |
|---|---|---|
| 2024-07-10 | 2024-07-10 | Issue 11 |
| 2024-07-10 | 2024-07-10 | Issue 12 |
Here is my exsiting DAX:
<code>CALCULATE(max(top_issue[created_at]),ALL(top_issue))
</code>
<code>CALCULATE(max(top_issue[created_at]),ALL(top_issue))
</code>
CALCULATE(max(top_issue[created_at]),ALL(top_issue))
Is there any change that i need to use?
you can update the measure like below.
<code>MEASURE =
VAR _maxdate =
MAX ( 'DimDate'[Date] )
VAR _maxdate2 =
MAXX (
FILTER ( ALL ( 'Table' ), 'Table'[Created At] <= _maxdate ),
'Table'[Created At]
)
RETURN
IF ( MAX ( 'Table'[Created At] ) = _maxdate2, "y" )
</code>
<code>MEASURE =
VAR _maxdate =
MAX ( 'DimDate'[Date] )
VAR _maxdate2 =
MAXX (
FILTER ( ALL ( 'Table' ), 'Table'[Created At] <= _maxdate ),
'Table'[Created At]
)
RETURN
IF ( MAX ( 'Table'[Created At] ) = _maxdate2, "y" )
</code>
MEASURE =
VAR _maxdate =
MAX ( 'DimDate'[Date] )
VAR _maxdate2 =
MAXX (
FILTER ( ALL ( 'Table' ), 'Table'[Created At] <= _maxdate ),
'Table'[Created At]
)
RETURN
IF ( MAX ( 'Table'[Created At] ) = _maxdate2, "y" )
<code>MEASURE =
VAR _maxdate =
date(selectedvalue(year),selectedvalue(month),selectedvalue(day))
VAR _maxdate2 =
MAXX (
FILTER ( ALL ( 'Table' ), 'Table'[Created At] <= _maxdate ),
'Table'[Created At]
)
RETURN
IF ( MAX ( 'Table'[Created At] ) = _maxdate2, "y" )
</code>
<code>MEASURE =
VAR _maxdate =
date(selectedvalue(year),selectedvalue(month),selectedvalue(day))
VAR _maxdate2 =
MAXX (
FILTER ( ALL ( 'Table' ), 'Table'[Created At] <= _maxdate ),
'Table'[Created At]
)
RETURN
IF ( MAX ( 'Table'[Created At] ) = _maxdate2, "y" )
</code>
MEASURE =
VAR _maxdate =
date(selectedvalue(year),selectedvalue(month),selectedvalue(day))
VAR _maxdate2 =
MAXX (
FILTER ( ALL ( 'Table' ), 'Table'[Created At] <= _maxdate ),
'Table'[Created At]
)
RETURN
IF ( MAX ( 'Table'[Created At] ) = _maxdate2, "y" )
3
you can try to create a column and filter the column to ‘y’
<code>Column = if('Table'[Created At]=max('Table'[Created At]),"y")
</code>
<code>Column = if('Table'[Created At]=max('Table'[Created At]),"y")
</code>
Column = if('Table'[Created At]=max('Table'[Created At]),"y")
or you can create a measure and in the visual filter set that measure to be ‘y’
<code>Measure = if(max('Table'[Created At])=CALCULATE(max('Table'[Created At]),all('Table')),"y")
</code>
<code>Measure = if(max('Table'[Created At])=CALCULATE(max('Table'[Created At]),all('Table')),"y")
</code>
Measure = if(max('Table'[Created At])=CALCULATE(max('Table'[Created At]),all('Table')),"y")
3