Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@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])
@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])
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])