Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
awitkowska
Frequent Visitor

how to get last date if report is filtered

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

 

DateAnalyzeValue
2018-05-05Yes1
2018-05-06Yes2
2018-05-07No3

 

Greetings from Warsaw, Agnieszka

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Try:

 

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Try:

 

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

thank you, it seemed to be really easy 😉

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.