Solved: How to sum multiple column ?

Paulyeo11 · ‎10-14-2020

Hi All

i get error msg for sum 3 column data.

amitchandak · ‎10-14-2020

@Paulyeo11 , USe SUMX or individual Sum

Sumx(Table, [Col1] +[Col2] +[Col3] )

or Sum(Table[Col1] )+ Sum(Table[Col2] )+Sum(Table[Col3] )

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎10-14-2020

@Paulyeo11 , USe SUMX or individual Sum

Sumx(Table, [Col1] +[Col2] +[Col3] )

or Sum(Table[Col1] )+ Sum(Table[Col2] )+Sum(Table[Col3] )

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

How to sum multiple column ?

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - January 2025

Fabric Community Update - January 2025

How to Get Your Question Answered Quickly

New Offer! Become a Certified Fabric Data Engineer