LASTDATETIME instead of LASTDATE (because duplicate date values error)

[mvananaken]

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!

[v-qiuyu-msft · Accepted 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

[v-qiuyu-msft · Accepted 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

[mvananaken · Accepted solution]

Hello @v-qiuyu-msft

Thank you! This works!