Forum Discussion
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...
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
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
