Forum Discussion
Julier
Helper III
Helper IIIsum multiple columns
I have three columns with the sames machine in some of the other columns and i have a column showing the sqm how can i show the value for each machine in one one column, for example combine all of th...
Hi Julier
- Unpivot Columns: Go to Power Query, select the three machine columns, right-click, and Unpivot Columns, or alternatively select the SQM and Unpivot other Columns.
- Rename the new value column to Machine Description.
- Group By: Use Group By on Machine Description to sum SQM.
- Analyze the data: For instance, create a slicer and use the Machine Description to filter the data by machine and show total SQM.
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedInWorked like a dream thank you!
pmreis
Most Valuable Professional
Most Valuable ProfessionalHi Julier
- Unpivot Columns: Go to Power Query, select the three machine columns, right-click, and Unpivot Columns, or alternatively select the SQM and Unpivot other Columns.
- Rename the new value column to Machine Description.
- Group By: Use Group By on Machine Description to sum SQM.
- Analyze the data: For instance, create a slicer and use the Machine Description to filter the data by machine and show total SQM.
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn
JulierWorked like a dream thank you!