Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear all,
I have a table with many columns, and I need to sort them. Target is for me to speed up the grouping step, and I read some resoucres in the web that Grouping can be faster if the data are pre-sorted.
Coming back to the sorting, is there a way to make it in one step intead of making it for each column?
What I did on sample file is this one:
#"Sorted Rows" = Table.Sort(#"Removed Columns",{{"Region", Order.Ascending}, {"Port_Type_1_2", Order.Ascending}})
I was thinking of using the following:
Headers = Table.ColumnNames(StuffingBoxChange2),
HeadersToRemove = List.Combine({{"Y3"},{"OEM_Y3_Volumes"},{"DISTRIBUTOR_Y3_Volumes"}}),
HeaderDifference = List.Difference(Headers,HeadersToRemove),
and at the end using HeaderDifference to select the column to sort.
Could you support?
Thanks.
Solved! Go to Solution.
Hi @Mic1979
#"Sorted Rows" = Table.Sort(#"Removed Columns", List.Transform(HeaderDifference, each {_, Order.Ascending}))
Stéphane
Hi @Mic1979
#"Sorted Rows" = Table.Sort(#"Removed Columns", List.Transform(HeaderDifference, each {_, Order.Ascending}))
Stéphane
Thanks!