Forum Discussion
How to change the date format?
sanchit This is controlled by the Locale Setting!
MM/DD/YYYY is the US format (and maybe some other countires not sure???)
But your csv file likely came form a place where they use DD/MM/YYYY
To have PBI recognize those as dates Go to File => Options and settings => Options => Locale => change to your country/region
sanchit This is controlled by the Locale Setting!
MM/DD/YYYY is the US format (and maybe some other countires not sure???)
But your csv file likely came form a place where they use DD/MM/YYYY
To have PBI recognize those as dates Go to File => Options and settings => Options => Locale => change to your country/region
Sean Thank you so much :smileyvery-happy: It worked.
I was trying it with DAX but in vain , is there a way to solve it using DAX , manually adding a new column with a different date format.
