Power BI Desktop

[Anonymous]

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 format)

[Anonymous · Accepted solution]

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]

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

[Anonymous]

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