How to get a Rank by store number and date in Power Query

[lennox25]

I need to rank by Store number and date in Power Query. It needs to be in power query as I am merging with another table that is already in rank order. I do not need a calculated column. It needs to be in Power Query in order for it to work.

Thank you

[lennox25 · Accepted solution]

I found this to be a more detailed solution 🙂 Adding a row rank based on a different column with Power Query – data witches (data-witches.com)

[DataInsights]

@lennox25,

This article may be of use:

https://blog.crossjoin.co.uk/2015/05/11/nested-calculations-in-power-query/