Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
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:
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
1 | 2 | 3 | 4 | 5 |
2 | 1 | 1 | 1 | 1 |
3 | 3 | 2 | 3 | 4 |
4 | 4 | 4 | 5 | 2 |
5 | 5 | 5 | 2 | 3 |
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
1 | 1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 | 3 |
4 | 4 | 4 | 4 | 4 |
5 | 5 | 5 | 5 | 5 |
Thank you.
Solved! Go to Solution.
Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.
let
Source = 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)
in
Custom3
Thank you. Worked for me too.
Hello, it worked for me, don´t know about how good or bad the performance might be, hope it helps.
let
Source = 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)
in
Custom3
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.