I have a data showing accounts, week, and status of accounts.
This is the expected output. I amtrying to create a measure for the right most column below. Appreaciate your help!
Solved! Go to Solution.
Hello, thank you for helping me out. I am just trying to understand the measure you have created because I am trying to apply it to the data which has a similar structure as example I shared.
I have tried RANKX and almost getting there, but how saw that you used SUMMARIZE.