The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everybody.
From this table:
id | Multivalue |
1 | A, B |
2 | A |
3 | B |
4 | A, B, C |
5 | C |
I need this table:
id | Value |
1 | A |
1 | B |
2 | A |
3 | B |
4 | A |
and so on. Thank you!
Solved! Go to Solution.
@NewPBIe ,
In Power query editor try the below steps,
1. Split the multivalue column by comma delimiter by selecting split at Each occurrence of the delimiter,
2. Select the id column and do a right click and then do Unpivot Other Columns,
3. Delete the attribute column to get the desired output,
Thanks,
Arul
@NewPBIe ,
In Power query editor try the below steps,
1. Split the multivalue column by comma delimiter by selecting split at Each occurrence of the delimiter,
2. Select the id column and do a right click and then do Unpivot Other Columns,
3. Delete the attribute column to get the desired output,
Thanks,
Arul
User | Count |
---|---|
78 | |
73 | |
37 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |