Forum Discussion
Resolver IGet a total Column Sum on a Pivot Column using power query
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
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
5 Replies
- MP-iCONN
Solved it with this - https://www.edureka.co/community/42820/dax-sum-of-values-from-many-columns-in-a-row
- 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
Community Support
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
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
