Get a total Column Sum on a Pivot Column using power query

[MP-iCONN]

I am working in Power Query and I pivoted a column and now I want to get a totol of each Months out.

How would I go about doing that.

Here is my sample data (spreadsheet) - Pivot Total Column Sum

Thank you for any help you can give.

Chad

[MP-iCONN]

Actually this helped for getting the sum but I also need a way to still show all Pivot columns which is the 2019-11 thru 2021-11.  If anyone can help I would greatly appreciate it.

Thank you.

Chad

[v-chenwuz-msft]

Hi @MP-iCONN ,

Is that u have successed reach the result you want?

1 Maybe you need to remove the [Months Out] and add costum column via =1, then select the costum column and unpoived other columns.

2 Pivot column -> and select value in the Values Column.

the result:

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MP-iCONN · Accepted solution]

I need the totals of each row 0 -12 like this.  With the article I included in this post I was able to solve how to get them but in order to do that it takes away the 2020-11 - 2020-05 months for example.

Thank you.

Chad

[v-chenwuz-msft]

Hi @MP-iCONN ,

You mean 2019-11 + 2019-12 + ... + 2020-05?

If yes, add a custom column

this will get the total result of each rows

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MP-iCONN]

Solved it with this - https://www.edureka.co/community/42820/dax-sum-of-values-from-many-columns-in-a-row