POWER BI DAX , How could we handle in a substraction with columns without values

[JOBRANCHES]

My 3rd column is the diference between 1st and 2ns. How could we return 0 when there's one column witthout a value?

3rd Column is a simple substraction between 2 Dax formulas.

[DataInsights · Accepted solution]

@JOBRANCHES,

Try this measure:

04 WA NS YoY =
IF (
    ISBLANK ( [Actual 2021] ) || ISBLANK ( [22 WA NS - Actual 2022] ),
    0,
    [22 WA NS - Actual 2022] - [Actual 2021]
)