Forum Discussion

SteveMForm's avatar
SteveMForm
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity 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
Icon for Helper III rankHelper 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...