Forum Discussion
Solved
Power BI - Split one cell into multiple columns
Dear All, How can I transform the variable BA in the left table to the wide format in the right one using Power BI? Many thanks in advance. Rudy
Hi Rudy123 ,
To achieve this, use Power Query and follow these steps:
1. Split Column BA by Delimiter to rows (not columns!)
2. Add Custom Column: Custom = 1.
3. Pivot columns: BA and Custom.
4. IN the Pivoted Column option change the Aggreate Value Function to Count(ALL) to receive zeros.
The result:
Memorable Member | Former Super User
If I helped, please accept the solution and give kudos!
Linkedin
Hi Rudy123 ,
To achieve this, use Power Query and follow these steps:
1. Split Column BA by Delimiter to rows (not columns!)
2. Add Custom Column: Custom = 1.
3. Pivot columns: BA and Custom.
4. IN the Pivoted Column option change the Aggreate Value Function to Count(ALL) to receive zeros.
The result:
| Memorable Member | Former Super User If I helped, please accept the solution and give kudos! |