Forum Discussion

JBGyro's avatar
JBGyro
Regular Visitor
2 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

BLANK() is not the same as ""

  • JBGyro's avatar
    JBGyro
    Regular Visitor
    2 years ago

    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. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, 

      to make it sort order change use index table and relate with your custom column.
      Ex of index table

      Index       MonthYear
      1              Active
      2              Jan 2023
      3              Feb 2023
      4              Mar 2023
      etc.
      This dim table MonthYear column sort order should change by Index. I hope you know this concept.

      Happy learning. 

    • mahenkj2's avatar
      mahenkj2
      Solution Sage
      2 years ago

      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.