Forum Discussion
Jagan_MFilterIT
Helper I
Helper IDate_time Conversion Issue
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 u...
Jagan_MFilterIT , This UK vs US date issue.
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])
amitchandak
Super User
Super UserJagan_MFilterIT , This UK vs US date issue.
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_MFilterITHelper I
Helper ISir,
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])