Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
You need to unpivot the month columns in Power Query. The you can create a table visual with a simple SUM on values
Proud to be a Super User!
Paul on Linkedin.
You need to unpivot the month columns in Power Query. The you can create a table visual with a simple SUM on values
Proud to be a Super User!
Paul on Linkedin.
Thank you! He was mentally blocked