Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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])
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
70 |