Forum Discussion
IF formula for Custom Column error
My goal is to replace empty date values in a table to a custom date value (31/12/9999 e.g.) by adding a new column where I use an IF function. The new column should be composed out of '31/12/9999...
Anonymous
IF ( ISBLANK ([Date Finished]) , DATE(9999,12,31), [Date Finished])
https://docs.microsoft.com/en-us/dax/date-function-dax
Refre the above link to learn about DATE function
Regards,
Manikumar
I don not see where this helps my problem? 🙂