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.
Hi,
Hope somebody can help me. I tried to search in google and that forum, but I couldn´t find and answer or solve my problem. I have multiple columns that sarted with letter "m*", and the database that I retrieve, could change along time. So, I need to unpivot the columns that started with letter m instead of doing manually.
Hope you Understand my explanation.
Thanks.
Solved! Go to Solution.
Hi @Anonymous
I created a small example.
Please see attached File's Query Editor
First we determine the columns to pivot
Then we can use this list in Table.Unpivot function
ColumnsToPivot = List.Select(Table.ColumnNames(#"Changed Type"),each Text.StartsWith(_,"m")), #"Unpivoted Columns" = Table.Unpivot(#"Changed Type", ColumnsToPivot, "Attribute", "Value")
Hi @Anonymous
I created a small example.
Please see attached File's Query Editor
First we determine the columns to pivot
Then we can use this list in Table.Unpivot function
ColumnsToPivot = List.Select(Table.ColumnNames(#"Changed Type"),each Text.StartsWith(_,"m")), #"Unpivoted Columns" = Table.Unpivot(#"Changed Type", ColumnsToPivot, "Attribute", "Value")
Thanks a lot for the quickly answer and for the solution!!
Thanks for the attachment too. I´m saving it like a treasure!
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |