Forum Discussion
Solved
How to Reverse Sort of Column Headers
How do you reverse the sort of column headers? In my example the sort is from 2018 to 2022. I would to go from most recent year to oldest. Help please!
Hi ShrimpSurf
You can create a conditional column to add a reverse index .
(1)Add a conditional column in Power Query .Set year 2022=1,2021=2…
(2)Go back to Desktop view, and choose the column [year] ,sort by the conditional column .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
To avoid creating a static table to sort years I would create a new column being 2100 - [Year] and simply sort on that new integer value