Date format

[Sujit_Thakur]

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  format it is detecting wrong 

For example 

My raw data has date 

2020-09-01

Which is literally September 1 2020

But power bi is showing January 9 2020 

Please help 

@amitchandak 

Need help 

Regards 

Sujit 

[Sumanth_23]

hi @Sujit_Thakur - you can created a calculated column if required to format the date as required for reporting - please refer to screenshot below

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[Sujit_Thakur · Accepted solution]

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]

@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)