Excel Forum

sum of column using its order powerquery

Jiří Hanzlíček

Active Member

Members

Forum Posts: 3

Member Since:
February 14, 2020

Offline

June 2, 2021 - 4:12 pm

I have a silly question - I need tu sum last 12 columns from 20 to make Moving Annual Total and I need to do it in power query. But headers of that columns are changing - they contains month names. So I found something, but i cannot make it work - here is syntax I need to correct from you:

= Table.AddColumn(Source, "MAT", each List.Sum({ Table.ColumnNames(Source){1}, Table.ColumnNames(Source){2}}), type number)

Thank you very much in andvance to helping me with my problem :-). Jiri

Mynda Treacy

Admin

Forum Posts: 4449

Member Since:
July 16, 2010

Offline

June 2, 2021 - 5:56 pm

Hi Jiri,

Your data is in the wrong format. You should never have the columns represent a separate month. This data needs to be unpivoted. From there you can create a PivotTable with your moving annual total.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Richard West, Wesley Burchnall, Clayton Watson

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Murat Hasanoglu

Brett Dryland

Saeed Aldousari

Bhuwan Devkota

Kathryn Patton

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Forum Stats:

Groups: 3

Forums: 24

Topics: 6222

Posts: 27291

Member Stats:

Guest Posters: 49

Members: 31913

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen