Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

Hi,

 

I have a table called Tracker which is on Direct Query

Loan IDLink Sent On (type Text)Funded On (Type Text)
1

2022-11-05 19:31:58

2022-11-05 19:25:58
22022-11-03 19:31:582022-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 IDLink 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 

22022-11-03 19:31:582022-11-04 19:37:462022-11-03 19:31:582022-11-03 

 

Please Help

Ashish_Mathur 

 

 

 

Thanks,

Dharani

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous You would have to use DATEVALUE in a measure.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        Anonymous Wrap your column reference in an aggregation like MAX.