Convert data column to date and time

[alunet]

I have such column data:

03-NOV-17 02.43.44.073000000 PM

What I want to get from this - 2 columns:

- date: 03.11.2017

- time: 02:43:44:0730 PM

Can you please help how to do it faster and neat?

I actualy done with Date column, but with Time meet some problems. I get data in this column like this:

2:43:44

but it converts into AM not PM, and without milliseconds. 

[v-shex-msft]

Hi @alunet,

Nope, dax not contains any function to get milliseconds value(format function also not include these)

FORMAT Function (DAX)

• Pre-Defined Numeric Formats for the FORMAT Function

• Custom Numeric Formats for the FORMAT Function

• Pre-defined Date and Time formats for the FORMAT Function

• Custom Date and Time formats for the FORMAT Function

You can consider to use text formula to store these precision time value in query edit.

Regards,
Xiaoxin Sheng