Marco Russo shows us how to build the equivalents of NULLIF and COALESCE in DAX:
The COALESCE function in ANSI SQL returns the current value of the first expression that does not evaluate to NULL. The syntax is:
COALESCE( <expression1>, <expression2>, <expression3>, … )We can rewrite this using IF in DAX this way:
Also read the big disclaimer at the top.