Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MP-iCONN
Resolver I
Resolver I

Get 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.

 

MPiCONN_0-1637354893072.png

 

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

 

Thank you for any help you can give.

 

Chad

 

1 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.

2021-11-22_6-15-02.png

 

Thank you.

 

Chad

View solution in original post

5 REPLIES 5
MP-iCONN
Resolver I
Resolver I

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

 

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.

vchenwuzmsft_1-1637567471761.png

the result:

vchenwuzmsft_2-1637567524955.png

 

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.

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.

2021-11-22_6-15-02.png

 

Thank you.

 

Chad

Hi @MP-iCONN ,

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

If yes, add a custom column

vchenwuzmsft_0-1637650993249.png

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
Resolver I
Resolver I

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors