Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to change the format from 2020-02-11T08:45:58.6470000 to 2020-02-11 in power bi, it returns wrong date and month if i'm using the format function
Solved! Go to Solution.
Hi @Anonymous ,
On the query editor be sure that you have the format of the columns as Date/Time then go to add column and select the Date Only, this will give you a new column with only the date part should work as expected.
then delete the initial column
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
On the query editor be sure that you have the format of the columns as Date/Time then go to add column and select the Date Only, this will give you a new column with only the date part should work as expected.
then delete the initial column
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you