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.   t...
  • DimaMD's avatar
    DimaMD
    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

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

Hi cammar As a result should this be a calculated column or measure?

  • cammar's avatar
    cammar
    Frequent Visitor
    3 years ago

    Column so each row has a total

    thanks DimaMD 

    • 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

      • cammar's avatar
        cammar
        Frequent Visitor
        3 years ago

        Brilliant, thanks 👍