Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
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.
Can you explain shortly why it is not a good idea to sort data in PQ ?
Can you explain shortly why it is not a good idea to sort data in PQ ?
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