Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

IF ( ISBLANK ([Date Finished]) , date(9999,12,31), [Date Finished])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Any more ideas?  amitchandak 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , That was DAX.

     

    Try this on Power Query

    if [Date Finished] =null then Date.FromText("9999-12-31") else [Date Finished]

  • manikumar34's avatar
    manikumar34
    Solution Sage
    5 years ago

    Anonymous , 

     

    You are trying DAX in Power query. 

     

    Please use the same DAX with Calculated column. 

     

    Regards, 

    Manikumar