Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mvananaken
Helper II
Helper II

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!

2 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello @v-qiuyu-msft

 

Thank you! This works! 

View solution in original post

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-qiuyu-msft

 

Thank you! This works! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.