Forum Discussion

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
5 years ago
Solved

Date format

Dear all , I know this may sound childish but I am suffering from last 2 days . My system is configured with date format of dd-mm-yyyy. My raw data has format of yyyy-mm-dd Even when I change  for...
  • Sujit_Thakur's avatar
    Sujit_Thakur
    5 years ago

    Ok sorry 😅😅😅 

    With last hope I just changed regional setting for date from English (US) to English (India)

    It is done now .

    May be you can guide me some more precautions steps to avoid such  errors in future

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
5 years ago

Ok sorry 😅😅😅 

With last hope I just changed regional setting for date from English (US) to English (India)

It is done now .

May be you can guide me some more precautions steps to avoid such  errors in future

amitchandak's avatar
amitchandak
Super User
5 years ago

Sujit_Thakur , Thanks for sharing what has worked

 

I would have expected power bi to take yyyy-mm-dd as yyyy-mm-dd , but seem like for india/UK date format it is YYYY-DD-MM

Now there additional step, but that will make sure we have the correct date irrespective of settings

 

new Date =date(left([date],4) , mid([date],6,2), right([date],2)