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,
My starting point is:
Division Grouping Value Target MValue MTarget
North Refund 2 4 5 6
North Rebate 4 2 5 5
North Cash 4 4 4 4
South Refund 8 1 3 7
South Rebate 2 3 4 11
South Cash 3 2 3 2
I require the end result to look like:
Division Grouping Value Target MValue MTarget
North Refund 2 4 5 6
North Rebate 4 2 5 5
North Cash 4 4 4 4
South Refund 8 1 3 7
South Rebate 2 3 4 11
South Cash 3 2 3 2
North GP 6 6 10 11
South GP 10 4 7 11
As you can see I require an additional row inserted for each division (there are many more divisions in my real data) with the value of 'GP' present in the Grouping column for that new row and the Value, Target, MValue, MTarget column values to be a sum of the 'Refund' and 'Rebate' Grouping values.
Please can someone help me achieve this?
Thanks.
Solved! Go to Solution.
Please take a look at the attached file to see all the detailed steps, but here's a quick overview:
Final Table:
Here's the file:
Please take a look at the attached file to see all the detailed steps, but here's a quick overview:
Final Table:
Here's the file:
Thanks @Anonymous Much appreciated.
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |