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...
Thank you for the reply. This helped as I changed my formula to:
Column = IF(ISBLANK([Finish Date]), "Active", FORMAT([Finish Date], "MMMM YYYY"))
This changes the column to Text, but now it is sorted alphabetically so there is more work to be done.
Hi JBGyro ,
Incase you use a date table and use month filter from that, this blank will not appear in the slicer. and together with follow the my earlier input, your user should be fine. Date is a dimension and should preferably come from dimension table and not the fact table. A proper date table will add lot of flexibility in your report.
Hope it helps.