Forum Discussion
How do I sum multiple columns, based on two specific text in a row?
Hi, I need to add multiple columns for certain values in a row. In this table below, I need to add for 2022 only April totals for five columns. Then I need to add 2022 for October, in a separate...
andii2617 Very easy if you unpivot your columns. Otherwise you can use this:
Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community
Hi Greg_Deckler,
For some reason the Multi-Column Aggregation did not work for me.
However, I was able to unpivot the columns, which function should I use to acheive the above?