Forum Discussion
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 format)
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
3 Replies
Anonymous , I think Dec 1899 is also considered blank, Can you share the formula you have used
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
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
