Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I've got an measure, following DAX:
Last Klacht = SUMMARIZECOLUMNS(ToiletStatus[Relatedklacht],LASTDATE(ToiletStatus[CreationDateTime]))
I want to visualize this in a card.
Note: directquery!
In the table are multiple dates with the same date, but all with other times. I got an error: a date column containing duplicate values. But i try to catch the LAST DATETIME in stead of Date.
How to fix thisAny help would be appreciated!
Thanks!
Solved! Go to Solution.
Hi @mvananaken,
You can create a measure like below, then place this measure in a card visual. It will display corresponding Relatedklacht value when its CreationDateTime is maximum.
Measure = LOOKUPVALUE(ToiletStatus[Relatedklacht],ToiletStatus[CreationDateTime],CALCULATE(MAX('ToiletStatus'[CreationDateTime]),ALL(ToiletStatus)))
Best Regards,
Qiuyun Yu
Hi @mvananaken,
You can create a measure like below, then place this measure in a card visual. It will display corresponding Relatedklacht value when its CreationDateTime is maximum.
Measure = LOOKUPVALUE(ToiletStatus[Relatedklacht],ToiletStatus[CreationDateTime],CALCULATE(MAX('ToiletStatus'[CreationDateTime]),ALL(ToiletStatus)))
Best Regards,
Qiuyun Yu
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |