Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
Solved! Go to 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.
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.
Thank you for your response. Trying your solution.