Forum Discussion

Helper III

9 years ago

Solved

sum multiple columns, how to?

Hi, Im new in powerBi and Im working in some datat wherein I need to calculate per row with multiple colums.

at 1 row for example, i have data like 1.00 1.25 2.00 3.00 4.50 5.00

now i have to add this, manually i can do it by saying column a + column b.... etc. but i dont know how to compute via sum

i tried sumx but i have error that says - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

thanks for the help.

Thiyags
Helper II
9 years ago
theo

You can find the solution in the below link

https://community.powerbi.com/t5/Desktop/SUM-row-by-row/m-p/22938#M7278
- theo
  Helper III
  9 years ago
  Thank you Thiyags.
  I actually have used that manual iteration but am looking for some sum formula.
  would like also to do similar calculation like standard deviation by row, etc.
  - Anonymous
    Not applicable
    9 years ago
    Have you tried the proper syntax using SUMX?
    
    MeassureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)
    
    That should do the trick.
    
    Br,
    Magnus
ZDBobbitt
Frequent Visitor
2 years ago
This tutorial shows an example of how to do so: https://www.statology.org/power-bi-sum-multiple-columns/