Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Difference between two dates along with null value should be zero

I created dax function for Difference between two dates along with null value i get the result difference but i can't get the null value as zero ,

My requirement is display the date difference along with Null value is zero but i didnt get zero it is get the value and minus value

HI Anonymous ,

Update your code like below:-

IF (
    ISBLANK ( 'sales dataset'[Sch.ship.date2] ),
    0,
    DATEDIFF ( 'sales dataset'[promise date], 'sales dataset'[sch.ship.date2], DAY )
)

Thanks,

Samarth