Forum Discussion
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.0...
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
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
Hi,
The same syntax i used for summing up the data in my table, but it is summing up data of individual column first and then adding to summed up data of another column.
Please Suggest any solution if you have on this.