Forum Discussion
Merge alternative columns dynamically used in a function
Hi Anonymous
If all files in a folder have the same format, you could Get Data from Folder with Power BI,
Then Click Edit, expand the "Content"
Select "Source.Name" and "Timestamp" columns and unpivot other columns
Rename the "Value" column to "combine Status"
Spilt the "Attribute" column
rename "Attribute.2" to "Series"
Select ""Attribute.2" and pivot columns
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
If all files in a folder have the same format, you could Get Data from Folder with Power BI,
Then Click Edit, expand the "Content"
Select "Source.Name" and "Timestamp" columns and unpivot other columns
Rename the "Value" column to "combine Status"
Spilt the "Attribute" column
rename "Attribute.2" to "Series"
Select ""Attribute.2" and pivot columns
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
you've already get a solution from v-juanli-msft.
But an alternative could be using functions like Table.ColumnNames or Record.FieldNames. You get a list of all columns of a table or a record which you can filter with List.Select. And then you can do your magic. It expects more programming skills in M.
