Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |