Need help with DAX

[indhu]

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.

[edhans · Accepted 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.

[indhu]

Thank you sooooo much 

[edhans]

You are very welcome.