Convert a text to DATE/TIME and Date Format - Direct Query

[Anonymous]

Hi,

I have a table called Tracker which is on Direct Query

Loan ID	Link Sent On (type Text)	Funded On (Type Text)
1	2022-11-05 19:31:58	2022-11-05 19:25:58
2	2022-11-03 19:31:58	2022-11-04 19:37:46

The Link Sent On and Funded On Column is of type Text.

How do i change the text format to Date/Text and Date 

Since the table is in direct query i couldn't change the format in power query or using format in Dax. 

I want the resultant table to be,

Loan ID	Link Sent On (type Text)	Funded On (Type Text)	format_Link Sent On_(type Date/Time)	format_Link Sent On___(type Dat)
1	2022-11-05 19:31:58	2022-11-05 19:25:58	2022-11-05 19:31:58	2022-11-05
2	2022-11-03 19:31:58	2022-11-04 19:37:46	2022-11-03 19:31:58	2022-11-03

Please Help

@Ashish_Mathur 

Thanks,

Dharani

[Ashish_Mathur]

Hi,

I do not know to o this in Direct Query.

[Greg_Deckler · Accepted solution]

@Anonymous You would have to use DATEVALUE in a measure.

[Anonymous]

Hi Sir,

It is throwing the below error,

If i write it as calculated column, and when i use it as visual, this is what it looks like

Thanks

[Greg_Deckler]

@Anonymous Wrap your column reference in an aggregation like MAX.