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