how to get last date if report is filtered

[awitkowska]

hello everybody,

I want to create measure which show last date, but whole report is filtered on some criteria (column analyze="yes")

I have used measure= Max (Table[Date]), but the result is  2018-05-06 because of the filtering.

I need date  '2018-05-07' as the last one, to show when the latest update of report was performed.

please help 🙂

small example below

Date	Analyze	Value
2018-05-05	Yes	1
2018-05-06	Yes	2
2018-05-07	No	3

Greetings from Warsaw, Agnieszka

[Greg_Deckler · Accepted solution]

Try:

Measure = MAXX(ALL('Table'),'Table'[Date])

[awitkowska]

thank you, it seemed to be really easy 😉