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 an issue I've been digging at but can't seem to get where I need to go. I'm newish to PowerBI and I could use a helping hand.
I have a query with 3 columns:
-ID
-Model
-Platform
Currently, the ID column contains only unique whole number values and the Model and Platform contain model numbers of materials and their model groups. There are multiple models and multiple groups in each cell per ID, and each piece is paired (IE, the first model matches the first platform, second with second, etc . So it looks something like this.
ID Model Platform
1 wx34,rx35 w,rx
2 rx55,ssw34,ssw34 rx,ssw,ssw
3 ssw22 ssw
What I'm trying to is break out the query and have each paired model and platform to be its own row, like this:
ID Model Platform
1 wx34 w
1 rx35 rx
2 rx55 ssw34
2 ssw34 ssw34
2 ssw34 ssw34
3 ssw22 ssw
etc
Any help and/or insight would be beneficial. I'm new to the forum so if I need to provide other info let me know.
Solved! Go to Solution.
@jmorrell,
It seems that the rows for ID 2 should be as follows.
Please check the detailed steps in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok1yu_Ho33gpCh2fj
Regards,
Lydia
@jmorrell,
It seems that the rows for ID 2 should be as follows.
Please check the detailed steps in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok1yu_Ho33gpCh2fj
Regards,
Lydia
Correct, it should have gone that way. I must have got a little hasty in my copy/pasting.
Thank you, this worked just fine
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |