Forum Discussion
Ranking a text category column
Anonymous if you added a RANK column based on Years, you can use the rank column on the sort by for Years. I would recommend adding rank column in PQ using the new function introduced recently Rank column (Preview) - Power Query | Microsoft Learn
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Anonymous if you added a RANK column based on Years, you can use the rank column on the sort by for Years. I would recommend adding rank column in PQ using the new function introduced recently Rank column (Preview) - Power Query | Microsoft Learn
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Thank you so much for your help. I didn't see the option to add a rank column, but I did choose to use PQ to add a rank conditional column. When grouping by rank on years appointed, I was able to successfully sort!
TY!