Date_time Conversion Issue

[Jagan_MFilterIT]

Hi, 

I have a strange issue in one of my requirement. I have a date column in my dataset that is coming in as text. When i try to convert this to Datetime the dates and months are getting mixed up : 

Example : if you look into the rows highlighted in Red, the Month and dates are swapped and the green rows are correct. 

Is there a way to fix this? beause of this all my time related measures are getting calculated incorrectly. 

[amitchandak · Accepted solution]

@Jagan_MFilterIT , This UK vs US date issue.

Option one https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

or create a new column in dax

date(mid([Delivery Datetime],7,4) , mid([Delivery Datetime],4,2), left([Delivery Datetime],2)  + timevalue([Delivery Datetime])

[Jagan_MFilterIT]

Sir, 

Thanks a ton. I used the second option to construct the date using your dax formula: 

date(mid([Delivery Datetime],7,4) , mid([Delivery Datetime],4,2), left([Delivery Datetime],2)  + timevalue([Delivery Datetime])