Forum Discussion

kaytrishjr's avatar
kaytrishjr
Frequent Visitor
4 years ago
Solved

How to sum multiple columns

I am trying to sum multiple columns (in Yellow). These are different workbooks. 

Need Help
  • filipeoliveira's avatar
    filipeoliveira
    4 years ago

    Have you tried to use SUMX? Something like:

     

    MeasureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)

2 Replies

  • filipeoliveira's avatar
    filipeoliveira
    Helper I
    4 years ago

    Have you tried to use SUMX? Something like:

     

    MeasureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)