Forum Discussion

sanchit's avatar
sanchit
Frequent Visitor
10 years ago
Solved

How to change the date format?

Hi, For Data: I have imported a .CSV file. I have two questions? My Date is in format 1/3/2016 7:56:00 AM (DD/MM/YYYY hh:mm:ss), but PowerBI is reading the Date as MM/DD/YYYY hh:mm:ss.         ...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    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's avatar
sanchit
Frequent Visitor
10 years ago

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.

Sean's avatar
Sean
Community Champion
10 years ago

sanchit Probably easiest way would be in the Query Editor

 

Split Column => by delimiter => Custom "/" at each occurence

 

And then Merge those columns in the "correct" order.

 

That should work!