Forum Discussion
RANKX tie break
Hi, trying to get 10 Most/least booked spaces, from a building desk booking table. I tried to do ranking and select top/bottom 10 from the list, but the ranking logic does not work properly, when...
Hi Anonymous ,
1, First, add a grouping and sum column in Power Query (Equivalent to the measure [TableTotalDuration].)
2, Sort the column created in the first step.
3, Add an Index column.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lionel-msft
Community Support
Community SupportHi Anonymous ,
1, First, add a grouping and sum column in Power Query (Equivalent to the measure [TableTotalDuration].)
2, Sort the column created in the first step.
3, Add an Index column.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.