Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI Desktop

Hi All,   Hope you are doing well.   I am trying to convert date format from Actual to DateActual as shown in below table. Is it possible to convert for December 1899 into same format(DateActual ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    As long as the data type for the [Actual] is date.

    In addition, "December 1899" (Month Year) can not be convert to date but "10/1/1899" (Month Day Year) can be recognized as date. So If your data is Month Year format, you need to create a calculated column to make it as Month Day Year format.

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I think Dec 1899 is also considered blank, Can you share the formula you have used

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak,

 

thanks for your reply. Currently, I am not using any formula. I am just changing some settings from the available options:

 earlier, it was set to Date Hierarchy but I hve changed it to DateActual

 

and yes, it is considering blank for December 1899