Filter to Most Recent TimeStamp

[ats1958]

I'm using an Azure SQL DirectQuery dataset and I'd like to add a filter to only show data for the most recent timestamp. There will be multiple rows for a given timestamp. Any way to do this with DAX? I'd like to avoid making changes to my database and application if at all possible.

This is what I'm using, but it's a measure so I can't use it as a filter. And I can't use the MAX function in a calculated column.

Latest1 = IF(MAX(Query1[timestamp]) = CALCULATE(MAX(Query1[timestamp]), ALL(Query1[timestamp])),
    "Latest", "")

[v-chuncz-msft · Accepted solution]

@ats1958,

You may drag the measure to Visual level filters.

[alexei7]

Hi @ats1958,

Why can't you use MAX in a calculate column?

The following works for me:

IsDateLatest = if(Dates[Dates]=MAX(Dates[Dates]),"Latest","") 

Hope that helps

Alex

[Anonymous]

HI Alex, your solution was perfect. Howver I got another question. What if have to apply he time stamp filter for individul items in the data. For ex : we have multiple applications and each of them are scanning different time. Hence we need to filter data for respective application based on their most recent timestamp. 

Please advise.

[ats1958]

@alexei7