Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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])
)
send sample data pbix and the desired result.
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])
)