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 am looking for a logic, This is the data I have
Fromplace Toplace Amountfrom AmountTo
--------------------------------------------------------------------------
Chennai delhi 100 50
Chennai mumbai 200 20
Delhi Chennai 300 50
I want to sum all the amount for one particular location and the output should look like this,
Place Amount
----------------------------
Chennai 350
Delhi 350
Mumbai 20
Any help is much appreciated 🙂
Thanks,
Indhu.
Solved! Go to Solution.
I did most of the legwork in Power Query for this. CHeck out this file. It involved several unpivot transformations, then removing the duplicates, then a simple SUM() function in DAX.
It is heavily dependent on the text in the columns not changing titles.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI did most of the legwork in Power Query for this. CHeck out this file. It involved several unpivot transformations, then removing the duplicates, then a simple SUM() function in DAX.
It is heavily dependent on the text in the columns not changing titles.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you sooooo much
You are very welcome.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 | |
102 | |
88 | |
63 |