Convert Timestamp into date-time

Try this. Adjust the table and column name accordingly. This formula assumes that your original column is in text format.

thank you, de Time convert part works fine, but the Date part has a issue.  It says"Connot convert value 'Oct 31 2023' of type text to type Date.

Well, you have two different formats of date in your data then. here's the updated DAX to handle both formats.

DateTime_Converted =
VAR textDateTime = datetimesample[datetime]
VAR containsTime = CONTAINSSTRING(textDateTime, "@")
VAR cleanedDateTime = SUBSTITUTE(SUBSTITUTE(textDateTime, "@ ", ""), ",", "")
VAR datePart = IF(containsTime, LEFT(cleanedDateTime, LEN(cleanedDateTime) - 12), cleanedDateTime)
VAR timePartWithMilliseconds = IF(containsTime, RIGHT(cleanedDateTime, 12), "00:00:00")
VAR timePart = IF(containsTime, LEFT(timePartWithMilliseconds, 8), timePartWithMilliseconds) // Extracting only the HH:MM:SS part or default to 00:00:00 if no time part
RETURN
DATEVALUE(datePart) + TIMEVALUE(timePart)

After a import of a new dataset, the dataconvert works.

Thanks you for your help.