Hi, I need to calculate the max date with data:
For example, I have data till 8/11/2024 and 9/1/2024 with no data.
How could i get the max date = 8/11/2024? This needs to be dynamically.
Thank you!
1 ACCEPTED SOLUTION
@clarainesgg Sample data would help but should be something like:
VAR __MaxDate = MAXX( FILTER( 'Table', [Some Column] <> BLANK() ), [Date] )Follow on LinkedIn
@ 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!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@clarainesgg Sample data would help but should be something like:
VAR __MaxDate = MAXX( FILTER( 'Table', [Some Column] <> BLANK() ), [Date] )Follow on LinkedIn
@ 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!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Fabric Community Sticker Challenge - Barcelona 2026
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
