Converting MySQL ifnull to ... I think if(isblank...

[Anonymous]

How do I write the MySQL statement   ifnull(meme_trm,"2099-01-01") >= "2020-01-01" in DAX?

I believe it is something like IF(ISBLANK(Lives[meme_trm]),(DATE (2099, 01,01)   ??????   )) lives is the DB name meme_trm is the field.

Thanks to all.

[amitchandak · Accepted solution]

@Anonymous , try one of the two

coalesce(Lives[meme_trm],DATE (2099, 01,01))

IF(ISBLANK(Lives[meme_trm]),DATE (2099, 01,01) ,Lives[meme_trm] )

[Anonymous]

Both of these worked perfectly, THANKS!