Hello, I have a silly question - I need tu sum 12 columns 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 example I need to correct from you:
Thank you very much in andvance to helping me with my problem
. Jiri
Power Query:
= 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
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)