Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm struggling with the DAX to achieve what looks like a simple objective. We're keeping a simple log of report values. I'm wishing to display a Card Visual of the Score for the Last Report Date for each KPI type. For example, I would like one card to display Revenue Growth 10%; the last known score for Revenue Growth, recorded on November 1st. Whatever logic or DAX is involved, I can replicate for the other KPI's. Thanks so much.
Hi,
Try this measure.
=LOOKUPVALUE(Sheet1[Score],Sheet1[Report Date],MAX(Sheet1[Report Date]),Sheet1[KPI],VALUES(Sheet1[KPI]))
Hope this helps.
Hey @Jeeo!
I was able to use the following measure, and attach it to a card visual to return the latest revenue number:
CALCULATE( SUM(Sheet1[Score]), FILTER( Sheet1, Sheet1[Report Date] = MAX(Sheet1[Report Date]) ), FILTER( Sheet1, Sheet1[KPI] = "Revenue Growth" ) )
Here is a screenshot of PBI Desktop:
Click HERE to access my .pbix file.
Hope this helps!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |