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...
Any more ideas? amitchandak
Anonymous , That was DAX.
Try this on Power Query
if [Date Finished] =null then Date.FromText("9999-12-31") else [Date Finished]