It would very useful to have more advanced option for the "Rank/Index" option when preparing the data. Chris Webb came with a possible solution but this should be something that PQ handles in an easier/wizard mode. This is the link of the solution: https://blog.crossjoin.co.uk/2015/05/11/nested-calculations-in-power-query/
2 Comments
- Here is also the equivalent on SQL. The function is RANK (Transact-SQL) https://msdn.microsoft.com/en-us/library/ms176102.aspx
- Status added:Needs Votes
