Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Urgent Repeat last date

‎11-13-2019 09:55 AM

Hi all,

 

How can I apply the ID date for all fields?

In this case all rows must return 05/09/2019 if ID = 11 and 29/08/2019 if ID =16.

 

Thanks a lot!

 

Work Item IdNEW COMPLETED
11 
1105/09/2019 00:00
11 
16 
16 
1629/08/2019 00:00
Labels:
Message 1 of 3
357 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable
In response to Anonymous

‎11-13-2019 10:24 AM

I found out by myself using the dax below. Thank you so much for trying to help.

 

CALCULATE (

MAX ( 'MEDIAS STATUS'[COMPLETED] );

ALLEXCEPT ( 'MEDIAS STATUS';'MEDIAS STATUS'[Work Item Id])

)

View solution in original post

Message 3 of 3
351 Views
2 REPLIES 2
Anonymous
Not applicable

‎11-13-2019 10:00 AM

send sample data pbix and the desired result. 

Message 2 of 3
355 Views
Anonymous
Not applicable
In response to Anonymous

‎11-13-2019 10:24 AM

I found out by myself using the dax below. Thank you so much for trying to help.

 

CALCULATE (

MAX ( 'MEDIAS STATUS'[COMPLETED] );

ALLEXCEPT ( 'MEDIAS STATUS';'MEDIAS STATUS'[Work Item Id])

)

Message 3 of 3
352 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All