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 dears
i am using power query and i am facing a complicated issue with time format. i have a data with mixed 12 hours, 24 format . i need to know how to get them all as the same format . i treid using spilit and extract function but with no luck.
some of the date format is listed like:
02/12/2024 23:14
and some of them like
2/13/24 12:35 AM
you can notice that year in the first date is YYYY and time is 24 format. in the second date the year is YY and timing is 12 hrs format
kindly find the below
Solved! Go to Solution.
hi guys
thanks god i found the soulution finally . i changed my regional format in my pc from english UK to English US and it has been solved
hi guys
thanks god i found the soulution finally . i changed my regional format in my pc from english UK to English US and it has been solved
Try adding locale to your code. Like this example.
= Table.TransformColumnTypes(#"Promoted Headers", {{"DATE", type datetime}}, "en-US")
Proud to be a Super User!
dears
kindly look what happened when i change the column to date and time
This will solve your issue. Add as custom column:
try DateTime.FromText([Date], "en-US") otherwise DateTime.FromText([Date], [Format="M/d/yy hh:mm tt", Culture="en-US"])
If you want to transform existing [Date] column, add this as new step (just replace Previous_Step😞
= Table.TransformColumns(Previous_Step, {{"Date", each try DateTime.FromText(_, "en-US") otherwise DateTime.FromText(_, [Format="M/d/yy hh:mm tt", Culture="en-US"]), type datetime}})
Please provide a sample data in a file you are importing into Power Query.
Proud to be a Super User!
Simply change the column data type to Date/Time...
= Table.TransformColumnTypes(Source,{{"DATE", type datetime}})
Proud to be a Super User!
i did and nothing change.
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.