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.
Hello,
Need help with the following please:
My aim is to split a row into few other rows based on a condition in power query
If cell content in column "Unit charge" = "Equal Charge"
then insert 8 new rows
input the following names in the adjacent column to the right named "New Unit charge": "MITTE", "PARIS", AMSTERDAM", "BARCELONA", "LONDON", "BERLIN", "MIAMI", "MADRID".
then split the amount that was originly in the main row named "Eqauly Charge" into 8 equal portions.
Finally, once this is done, I would like to rpevent rows with the content "Eqaul charge" to split again. so may be change the name of the Eqaul charge to "Eqaul charge-split"
If cell content in column "Unit charge" <> "Equal Charge" then copy the value into the column "New Unit Charge".
I have attached a template that shows the original data and the desired transformation.
Please let me know if you can help.
Thanks
Hi@ AnisAnalyst
After my research, you do these follow my steps like below:
Step 1:
Enter a reference table like below
Step 2:
Duplicate the basic table and filter the duplicate table
Step 3:
Merge duplicate table with reference table
And expand the table
Step 4:
Select column 18-Jan and then click Transform ->Standard->Integer-Divide
Do it by other columns in the same way.
Step 5 :
Filter basic
Step 6:
Append two table Home->Combine->Append Queries
Close&Apply
Step 7:
Add two column
NEW Unit Charged = IF(Table1[Unit Charged]="Equal charge",Table1[Table3.Unit charged],Table1[Unit Charged]) New Unit Charge = IF(Table1[Unit Charged]="Equal charge",Table1[Table3.New Unit Charge],Table1[Unit Charged])
Result:
You could hide and rename other useless column
Here is Demo, try it please
https://www.dropbox.com/s/lgts0dpbxifp7lo/Add%20conditional%20rows.pbix?dl=0
Best Regards,
Lin
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 |