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
Gabry's avatar
Gabry
Icon for Super User rankSuper User
2 years ago

Can't you just exclude those nulls?

 

It doesn't make much sense to put not specified because "not specified" where will be shown in the graph?

 

You can put a date like 01/01/1900 and then filter out this date. 

Or you can make a measure that count this 01/01/1900 dates and says, there are x not specified dates

  • SteveMForm's avatar
    SteveMForm
    Icon for Helper III rankHelper III
    2 years ago

    Hi Gabry 

     

    I dont want to exclude them- for example, I have one visual using this data as a Gantt which we show a line for the item, which I want for visibility, but the start and end date (the 2 date columns) being not filled (as not known yet) mean it has a line that is 1 single day of todays date, and I'm happy with that.

     

    Any excluding, or replacing with a date then filtering out will remove the item, which I dont want