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 ...
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
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