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...
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

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

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

    Hello v-qiuyu-msft

     

    Thank you! This works!