topic Re: Convert String to date and time in DAX Commands and Tips

Convert String to date and time

mcdermjj — Fri, 23 Jun 2023 10:32:42 GMT

Hi There

I would like to convert the string formats below in my DATETIME column into a useable Date and Time Column such as 2023/06/16 22:45:00 , so Power Bi can recognise it as a real Date and time format for use. Thanks

2023061612245000

2023061612244900

2023061612244800

Re: Convert String to date and time

devanshi — Fri, 23 Jun 2023 10:42:15 GMT

Just select the that column & change datatype text to date/time. It automatically convert in date time formate

Re: Convert String to date and time

mcdermjj — Fri, 23 Jun 2023 12:48:15 GMT

Hi there, unfortunatley that gave me error 😞 so trying adding a column and extracting the first 8 Characters. for date and then changing data type to date ( That seems to work ) and then Just trying the last 8 for time and its not working for data type change for time.. will keep trying

Re: Convert String to date and time

devanshi — Mon, 26 Jun 2023 05:17:30 GMT

Try this one,
Go to transform tab, then

Click one from this , select date/time datatype .