Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago

How do I convert date serial to date and also handle zero values

How do I convert a date serial value to a date, but also need to handle zero value .   if (datevalue(Termed) = true then Datevalue(termded) else 0   Pleae help with the correct syntax.   Karen
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

In DAX, the syntax is:

 

IF(true/falsetest,true statement, false statement)

 

So, something like:

 

IF(datevalue[Termed] = TRUE,DATEVALUE([termded]),0)