Forum Discussion

SteveMForm's avatar
SteveMForm
Helper III
2 years ago

How do I replace a null value in a date column?

Hi Folks   I have 2 date columns with some null values in, but it wont let me replace the null with text to say 'not specified' as it requires a date.   I don't want any other dates for these nul...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi, create new custom column

 

if [Date] = null then "not specified" else Date.ToText([Date], "yyyy-MM-dd") //you can specify any output in 2nd argument of Date.ToText function

 

 

  • SteveMForm's avatar
    SteveMForm
    Helper III
    2 years ago

    Hi dufoq3 

     

    so if I create a custom column (will be 2- one for start date and one for end date) and apply that Power Query Formula, will visuals like Gantt or any other visual which uses dates in conjunction with my dimDates table still pick up the date formats correctly? I suppose I can trial it...