In power query, Is it possible with over 100 rows to sort each column so that all columns are in ascending order?
For example, once I load my data it looks like this:
Go to Solution.
Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.
letSource = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTICYmMgNgFiU6VYnWiwiCEKBokaQ9Uh1INETaA6IbpBsiBRUyjPFK4+NhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Column 1" = _t, #"Column 2" = _t, #"Column 3" = _t, #"Column 4" = _t, #"Column 5" = _t]),Custom1 = Table.ToColumns (Source),Custom2 = List.Transform(Custom1, List.Sort),Custom3 = Table.FromColumns(Custom2)inCustom3
View solution in original post
Thank you. Worked for me too.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.