Forum Discussion

Enan's avatar
Enan
Icon for Helper I rankHelper I
4 years ago

Date Error in table

Hi Guys, I am having an error (Pic 1), Need your guidance and help plzz. I have load the data in the new pbix file but in new file error is not coming. (Pic 2) Thank you
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Enan , Your system is using US format and in Power BI you are getting dates in UK Format.

 

You need to create a new column in Power Query

#date(Number.FromText(Text.End([Date],2) ) ,Number.FromText(Text.Middle([Date],3,2) ) ,Number.FromText(Text.Start([Date],2) ) )

 

 

Discussed same here

Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0