Need Support with MQuery

[PBI_007]

Hello Power BI Gurus,

I am new to Power BI and need help to rank my data based on two columns using Power Query.

I have explored ranking in desktop but my boss wants me to use Power Query.

Can anyone help me please?

I am providing some sample data base don which the ranking needs to be done.

ItemName	EndDate
Recliner	10/31/2020
Chair	10/31/2020
Recliner	10/31/2020
Recliner	04/30/2020
Chair	11/30/2019
Recliner	01/01/2021
Recliner	04/30/2020
Recliner	10/31/2020
Chair	11/30/2019
Chair	11/30/2020
Chair	10/31/2020

[PC2790 · Accepted solution]

Hello @PBI_007 ,

You would need to use the concept of grouping and indexing here.

I had a similar requirement and was able to achieve it.

Refer the attached file.See it's helpful for you.

Appreciate your Kudos if the solution helped.

[PBI_007]

Thank you for your response. Trying your solution.