Forum Discussion

mvananaken's avatar
mvananaken
Icon for Helper II rankHelper II
9 years ago
Solved

LASTDATETIME instead of LASTDATE (because duplicate date values error)

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!

Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    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