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.
i have a datasource that is converted into a table. There are columns within the table that contain multivalues separated by a semi colon, So for example like this:
ID | Department | Years | Colour |
1 | Billing;Stores;Office | 3 | Red;Blue |
2 | Office;Billing | 7 | Green;Orange |
3 | Stores | 10 | pink |
So i am trying to extract the multivalue fields, perhaps put them into their own table? But i cannot see anyway of doing this after i have already converted the original datasource into a table. Any ideas?
Solved! Go to Solution.
Hi @cheezy ,
If I took your question correctly then you could follow below steps:-
1. Select Department column then use split column by delimiter
2. Now select the options as below:-
3. Follow the same for colour column.
4. Final output:-
Refer the file below.
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @cheezy ,
If I took your question correctly then you could follow below steps:-
1. Select Department column then use split column by delimiter
2. Now select the options as below:-
3. Follow the same for colour column.
4. Final output:-
Refer the file below.
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
thanks for your help - this works
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |