Forum Discussion

Enan's avatar
Enan
Helper I
3 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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 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

  • ReneMoawad's avatar
    ReneMoawad
    Resolver III
    3 years ago

    The Date format in the first image is set to MM-DD-YYYY and your data is DD-MM-YYYY

    • Remove the step that is changing the Date format of the date column
    • Right click on the Column name, Change Type, Using locale

     

     

    • select Data Type "Date" and change the Locale to  English (United Kingdom)