Forum Discussion
Create multiple columns from rows
Hello All, I have the following table. My current key is a combination of ID & Type. For each type, I have to get 7 columns with the following schema (type + each following column) : Coal Value ...
Hi Anonymous ,
Here are the steps you can follow：
1. In power query – select [schema] – Spliy Column – By Delimiter.
Split at : Left – most delimiter.
2. Select [schema.2] – Transform – Pivot Column.
Values Column – [Flag]
Aggreate Value Function – Don’t Aggregate
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous , You can create a new column with group values
example
Sumx(filter(table, Table[ID] = earlier(Table[ID])) , Table[threshold value] )
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
Thanks ! What about diplaying the correct Value chain, as sumx does not handle string values?