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
