Forum Discussion

vipinrajan's avatar
vipinrajan
Frequent Visitor
1 year ago
Solved

Sum Multiple column

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 1...
  • vipinrajan's avatar
    vipinrajan
    1 year ago

    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
    )
    )
    )

vipinrajan's avatar
vipinrajan
Frequent Visitor
1 year ago

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
)
)
)