Forum Discussion
Solved
Rank changing based on date for each sub-group
I have a table containing data of ProjectID and each ProjectID has multiple periods. Each ProjectID is like a sub-group in my data in 'ProjectID' column. Each ProjectID has multiple period numbers th...
If the Periodnumber is no measure, i only know that you have to create one first:
Measure = sum('Table'[PeriodNumber])And than use rankxMeasure 2 = RANKX(ALLEXCEPT('Table','Table'[ProjectID]),CALCULATE([Measure]),,DESC)Perhaps someone know how to avoid to create the first measure?
Ashish_Mathur
Super User
Super UserHi,
Share some data to work with and show the expected result.