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'm trying to extract and duplicate rows based on the content of a particular column;
I'm not sure how i can achieve this... I've tried using the extract functionality but this doesn't seem to work...
The below table is what my data currently looks like:
Exception ID | Exception Name | Related Issues |
Ex-1 | Example 1 | Issue-0001 Issue-0002 Issue-0003 |
Ex-2 | Example 2 | Issue-0004 Issue-0005 |
This is what i want it to look like. You can see the related issues have been extracted and the rows duplicated.
Exception ID | Exception Name | Related Issues |
Ex-1 | Example 1 | Issue-0001 |
Ex-1 | Example 1 | Issue-0002 |
Ex-1 | Example 1 | Issue-0003 |
Ex-2 | Example 2 | Issue-0004 |
Ex-2 | Example 2 | Issue-0005 |
Any help would be much appreciated!
Thank you!
Solved! Go to Solution.
@jonbox try below
1.First replace the blank value with null value by selecting both the column.
2.Second select both the column and fill down the data as per below snap.
@jonbox try below
1.First replace the blank value with null value by selecting both the column.
2.Second select both the column and fill down the data as per below snap.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |