Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cannot Convert value " of type to type Date

I have the dax formula below to create a new column which I have set to be Date format. It was previously working but all the suddent today I am getting "Cannot Convert value " of type to type Date" which only goes away if I set the column back to text format, which will not work for me. Any ideas on how to fix it?

MonthYear = Format (Pipeline[Award Date], "MMMM, yyyy")
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    7 years ago

    I'm not able to replicate the issue and if what you are saying is correct about the original data column then i don't see why it should not work.

     

    What if you try and duplicate the original column and change the format under modeling instead of using a calculated column

     

     

    This gives you pretty much the same format as you desired

5 Replies

  • Gordonlilj's avatar
    Gordonlilj
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi,

     

    It seems it's having trouble converting to a date datatype.

    Is it possible you could provide the data for the Pipeline[Award Date] column?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago


      I have gone through the column and found no bad data in this column, my above formula runs perfectly fine if I have the calculated column set as a text datatype. However I need to have it as a date type to sort 

      • Gordonlilj's avatar
        Gordonlilj
        Icon for Solution Sage rankSolution Sage
        7 years ago

        Right, so the problem most likely lies then with the calculated column itself.

        Probably should have asked this previously as well but could you provide the data for the calculated column when it's in text format