cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP-iCONN
Helper II
Helper II

Pivot Data list sum

I created a report that is able to show me amount shipped historically by Month-year.

 

The problem is when I pivot the data the Month-Year will change and I am not sure how to get the new months into my list sum totals by row.

 

Currently the step shows this (which will error because I now have 2021-12 to also sum):

 

= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum({[#"2020-12"], [#"2020-11"], [#"2021-01"], [#"2021-02"], [#"2021-03"], [#"2021-04"], [#"2021-05"], [#"2021-06"], [#"2021-07"], [#"2021-08"], [#"2021-09"], [#"2021-10"], [#"2021-11"]}), type number)

 

MPiCONN_0-1638386288380.png

 

 

One final question I have.  This new month won't show up in my table view visual either.  Do I have to go into this report each time to get the new month to be shown in table view?

 

Thank you for any help/advice.

 

Chad

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

 

= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum(List.Skip(Record.ToList(_))))

 

View solution in original post

1 REPLY 1
CNENFRNL
Community Champion
Community Champion

 

= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum(List.Skip(Record.ToList(_))))

 

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors