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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
trentos
New Member

Help with filtering automatically the most recent date

Hi Power BI community, 

 

DAX/power BI newbie here. 

 

I need help with something I am trying to build in DAX for my organisation. 

 

Essentially, I want a dashboard that only shows the most recent date as a filter. The data point I want to show is "lost revenue" which is a calculated measure that uses other created measures to return a value.

 

I have looked around the forums and can see that I can create a column or measure using the MAX function which I have done

 

Most Recent Date Column =
CALCULATE(
    MAX(clogs[Date]),
    ALL(clogs[Date])
)
 
This seems to generate the most recent date as a value for each row - which is what I wanted.. However, I can't seem to use this date to filter against my created measure "lost revenue". Maybe it is the way my data is structured?
 
I thought to use CALCULATE and SUM function for the lost revenue with the recent day measure to filter by only the most recent date however that does not seem to work as I can't sum the lost revenue calculated measure.
 
I want a dashboard guage visually to automatically show the most recent data without having to use the date slicers, so this will update every database refresh - which is daily in my organisation. 
 
As you might be able to already tell, I am still quite inexperienced with this DAX and get confused a lot with the various expressions. Any help would be most appreciated - and apologies in advance if my above question is not clear. 
 
Trent
1 REPLY 1
JW_van_Holst
Resolver IV
Resolver IV

Please provide sample data and expected output (of a downloadable pbix)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.