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 All
Please help me.
Can I merge columns in the Query editor by column name (if the colname contain the setted text)?
And how can i do?
I would like to merge the columns (in the query editor), which name started with "LinkedStore" string. And this "LinkedStore_* " columns number is dinamically changing.
For example:
I saw in the advance editor, and combine the following but... 😞
let Source = #"HUData (2)", ColNames = Table.ColumnNames(Source), TransformCommand = List.Transform(ColNames, each {_, type text}), #"Changed Type1" = Table.TransformColumnTypes(Source, TransformCommand), #"Merged Columns" = Table.CombineColumns(#"Changed Type1", ColNames,Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged") in #"Merged Columns"
Thanks a lot
Instead of merge columns, I'd suggest you do a "unpivot".
Then unpivoted data model are more normalized and it is easy to get the "merged" column in a visual by using a measure. See more details in the attached pbix.
merged values = CONCATENATEX('Table','Table'[Value],",")
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |