Forum Discussion
Sum column data according to filter
Hello everyone, I need your help and guidance with the following case.
I have the table shown in the image, where I have data grouped in multiple columns. I need to find the form, which according to the filters, gives me the sum of the data in that column.
Very thankful
You need to unpivot the month columns in Power Query. The you can create a table visual with a simple SUM on values
2 Replies
PaulDBrownCommunity Champion
You need to unpivot the month columns in Power Query. The you can create a table visual with a simple SUM on values