Forum Discussion
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 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
Need help
Regards
Sujit
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
3 Replies
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 , 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)
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!
