Forum Discussion
Possible to insert text in date column?
I have a date column that shows completed dates for projects, this is a data group to based off the actual date column so we can get the MMMM YYYY format. The blanks in this column represent projects...
Hi JBGyro ,
I would suggest to use a simpler technique in such case.
Keep this column intact as Date column, instead creat a custom column say 'Status' which check if Completion date column have date then say 'Completed' else 'Not completed'.
This keeps things simple, date column remain Date column, use Status column in report as a slicer, legend etc, now u can connect completion date column to a standard Date table as well.
I think such a technique is cohesive to easier reporting.
Hope it helps.
Thank you for the reply. I'm actually already doing this, but some confusion arises when the user wants to see active and completed projects, but then doesn't select the (Blank) option along with specific 'Completed' months.
