Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ivanmay
Regular Visitor

Sum column data according to filter

Hello everyone, I need your help and guidance with the following case.

ivanmay_0-1634660425803.png

 


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

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

You need to unpivot the month columns in Power Query. The you can create a table visual with a simple SUM on values





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

You need to unpivot the month columns in Power Query. The you can create a table visual with a simple SUM on values





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thank you! He was mentally blocked

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors