Forum Discussion
powerquery sort based on two columns
hello,
I have a table with three columns, and I would like to sort on 2 columns,
I do not find how to do.
While waiting for a relevant solution, I merged the two columns and sorted it out, but I think there is more efficiency.
I attach an excel file with the starting table and the desired result.
https://www.dropbox.com/t/DsQFZmgLoay8YUNK
Thnaks a lot
Philippe
7 Replies
Sort by the first column. Sort by the second column. You will see little numbers appear
Or you can do it in code.
Note: Sorting in Power Query is a red flag/code smell. In the vast majority of cases you do not need/want to sort your data in Power Query.
Yes, i'm interested too.
And in my project, i need sort tables because thay are not read in order and for the transformations, i need to get table sorted by date and by item.
Sincerly
Philippe
How Power Query Thinks: Taking the Mystery Out of Streaming and Query Folding (Video) | Ben Gribaudo
Sorting is covered around the 20:00 mark but you will want to watch the entire video, multiple times.
