Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ReportingUser | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |