Forum Discussion
Need help with DAX
I need to convert the tableau calculated field to Power BI zn(sum([column 1]) + sum([column 2])) Thanks in advance
BA_Pete I tried the same but the values seems to be wrong.
In tableau I got another value and in Power bI got another value.
Is there any other reasons
Almost impossible to say without being able to see the detail behind it all.
Coalesce should work fine, but you could try this as an alternative:
VAR __calc =
SUM(yourTable[Column1]) + SUM(yourTable[Column2])
RETURN
IF( ISBLANK(__calc), 0, __calc)
Pete