Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have a visualization that looks like this:
And I would need to create MEASURE called Latest LAPSED Status Date that returns, for each row, the latest date where each Partner had the status of Lapsed. The result should be a table like this:
Could anybody help me withe the DAX Code ? I would really appreciate it !
Thanks a lot in advance,
Joaquin
Solved! Go to Solution.
Hi @johmedrano,
You can try to use below formula to find out last update date of each partner:
Last Update = CALCULATE ( MAX ( Table[Date], FILTER ( ALLSELECTED ( Table ), Table[Partner Name] = SELECTEDVALUE ( Table[Partner Name] ) ) ) )
Regards,
Xiaoxin Sheng
Thanks !
Hi @johmedrano,
You can try to use below formula to find out last update date of each partner:
Last Update = CALCULATE ( MAX ( Table[Date], FILTER ( ALLSELECTED ( Table ), Table[Partner Name] = SELECTEDVALUE ( Table[Partner Name] ) ) ) )
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |