Sum multiple columns

[Anonymous]

Hello everybody,
I have a problem. I have a table with innumerable columns like sales_1, customer_1, sales_2, customer_2, sales 3, customer_3 and so on (it goes to 50) Is it possible to add up all columns with the name "sales_total".

Thanks a lot.

[AlB · Accepted solution]

Hi @Anonymous 

You should unpivot all those columns. Then it will be much easier to operate. Check this out:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers