Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX IF Statement

I am new to writing DAX and trying to write the below IF statement:   Forecast/Actual= If TableX(actual amount) has a value, use TableX(actual amount) value. If TableX(actual amount) has no value, ...
AND
DAX
if
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

DAX offers the ISBLANK() function that you can use to solve part of your problem.

VAR replace = OR(IF( ISBLANK(TableX[actual amount]) ,  TableX[actual amount] =0)

RETURN IF(replace,tabley[forecast amount],tablex[actual amount])

 

this separates the test for whether or not you want to replace the value by using the OR function, if either of the arguments to OR is true it returns true.

If replace = true then you return the forecast, otherwise the actual