topic Sum Multiple column in DAX Commands and Tips

Sum Multiple column

vipinrajan — Fri, 11 Oct 2024 10:15:16 GMT

Dear All,

From DAX how to get TOTAL based on below table, if coulmn1 and 2 same value then its sould pick either one and remain raws based on value.

Column1	Column2	Total
	5	5
10	10	10
20	20	20
30	30	30
35		35
25		25

Please help.

Regards,

Vipin

Re: Sum Multiple column

vipinrajan — Fri, 11 Oct 2024 12:07:47 GMT

NewColumn =
IF( TableName[Column1] = TableName[Column2],
TableName[Column1],
IF( TableName[Column1] = 0 && TableName[Column2] = >0,
TableName[Column2],
IF( TableName[Column1] = >0 && TableName[Column2] = 0,
TableName[Column1],
BLANK() -- Or any other default value if no condition matches
)
)
)