Urgent Repeat last date

[Anonymous]

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 Id	NEW COMPLETED
11
11	05/09/2019 00:00
11
16
16
16	29/08/2019 00:00

[Anonymous]

send sample data pbix and the desired result. 

[Anonymous · Accepted solution]

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])

)