Seperate out the date and time

[Learner_SG]

Hi , my data field for date and time is in this manner : 

2022-01-04T02:26:38.2530000Z

.

How do I separte the time and date? 

[DataInsights · Accepted solution]

@Learner_SG,

Try these custom columns in Power Query:

DateTime.Date([DateTime])

DateTime.Time([DateTime])

[Syndicate_Admin]

Hello:

I'm looking to do the same but can't find the Datetime.date() function

[DataInsights]

@Jprada,

These are Power Query functions, not DAX.

[Syndicate_Admin]

@Syndicate_Admin

Could you tell me how I can do it in DAX code, I'm working with a table that doesn't allow me to do it in power Query.

[DataInsights]

@Jprada,

Create these calculated columns:

Date = Table1[DateTime]

Time = Table1[DateTime]

Set the data type for each column using the Data type dropdown: