Forum Discussion

cammar's avatar
cammar
Frequent Visitor
3 years ago
Solved

DAX for adding over 5 columns

Hi all,

 

I have these columns in powerBI and need all 5 adding by row 

I have tried a SUM('Sheet'[column1]) +SUM('Sheet'[column2]) ..... but to no avail - any help hugely appreciated.

 

thanks 

5 Replies

      • DimaMD's avatar
        DimaMD
        Icon for Solution Sage rankSolution Sage
        3 years ago

        cammar See the file there are 2 examples, as a calculated column and as a measure.
        Please respond if this is your desired outcome

  • Mahesh_Gandham's avatar
    Mahesh_Gandham
    Regular Visitor
    3 years ago

    Use Iterator Function like SUMX(TableName, Column1+Column2+Column3+Column4+Column5)

    you will get your answer