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.
Hi! I have "Change Impacts" that have have 2 columns with infotmation. One is "E2E" and the other is "Type". Those columns can have more than one info, splited with a "," as yoy can see in the "Type" column.
I need to create graphs counting each "Chane Impact ID" by "E2E" and "Type", incuding the values that are splitted by a ",". Any idea on how I could do it?
Solved! Go to Solution.
what about split to rows?
then you can count each value separately.
Proud to be a Super User!
Hi,
In the Query Editor, split the contents of the Type column by rows using the comma delimiter.
Hi,
In the Query Editor, split the contents of the Type column by rows using the comma delimiter.
what about split to rows?
then you can count each value separately.
Proud to be a Super User!
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |