Forum Discussion

NaniG's avatar
NaniG
Frequent Visitor
3 years ago
Solved

Converting Text To Date

HI
I am new to power BI . I am getting data from SQL server . 
I am have text type column is there i want to convert to date column but some data are not organizied way .

How i can handle the issue . Please see below attach pic 

 

  • Hi NaniG 

    Please take a look on the following Power Query formula

    Date.FromText - PowerQuery M | Microsoft Learn

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

    -----------------------------------------------------

    LinkedIn

1 Reply

  • Mikelytics's avatar
    Mikelytics
    Resident Rockstar

    Hi NaniG 

    Please take a look on the following Power Query formula

    Date.FromText - PowerQuery M | Microsoft Learn

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

    -----------------------------------------------------

    LinkedIn