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 column of merged data which stores a type and a number and sometimes several types and numbers.
I would like to br able to report on the different types and their values but I can't figure out the best way to do this.
An example of the data in this column is shown below....
Anyone have any thoughts? Many thanks
COLUMN A
Type C: 8; Type F: 2;Type B: 4;Type L: 4;
Type A: 15; Type C: 15;
Type C: 6; Type B: 6;
@BhaveshPatel shows a good solution. One thing to consider is to be careful when the number of items to split may increase (I couldn't quite tell from the screen shots if Bhavesh's solution handles this)
see this article for what I'm referring to
https://www.linkedin.com/pulse/take-care-when-splitting-cells-wyn-hopkins
This is your sample column, "Type C: 8; Type F: 2;Type B: 4;Type L: 4;"
Split first by the delimiter ';' and then split the resulting colums by delimiter ':'. Shouldn't cause a probem ideally
Hi There,
You can use the split columns functionality in query mode. Please refer to this attached photos for stepwise procedure.
Thanks & Regards,
Bhavesh
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |