DAX for adding over 5 columns

[cammar]

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 

[Mahesh_Gandham]

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

you will get your answer 

[DimaMD]

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

[cammar]

Column so each row has a total

thanks @DimaMD 

[DimaMD · Accepted solution]

@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]

Brilliant, thanks 👍