Solved: Converting Text To Date

NaniG · ‎12-06-2022

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

Mikelytics · ‎12-06-2022

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.

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

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!

View solution in original post

Mikelytics · ‎12-06-2022

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.

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

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!