Not able to convert text to date

[Maddyqc]

Hi,

I am new to Power BI. I am not able to convert text to date. I tried calculated column method, but it requires the text to be in yyyy-mm-dd format, mine is in the other way. I tried in Power query too. Can some one help, please?. Thank you. 

[az38 · Accepted solution]

Hi @Maddyqc 

you were close to aim

DATE(
VALUE(RIGHT(cases[Date_report], 4)),
VALUE(LEFT(cases[Date_report], 2)),
VALUE(MID(cases[Date_report], 4, 2))
)

[az38 · Accepted solution]

Hi @Maddyqc 

you were close to aim

DATE(
VALUE(RIGHT(cases[Date_report], 4)),
VALUE(LEFT(cases[Date_report], 2)),
VALUE(MID(cases[Date_report], 4, 2))
)

[vinodanandan]

Hi @az38,

Does the solution to conver text to date works with Live Query Mode.

Thanks,

Vinod 

[Maddyqc]

Thank you, Super User II

[Maddyqc]

Hi Super User II,

I still have a problem with it. Instead of taking the first two as date, it is considered as month (March). It is May 5th, instead of March 5th.How do we switch it?

[az38 · Accepted solution]

@Maddyqc 

it depends on regional settings. just replace arguments

DATE(
VALUE(RIGHT(cases[Date_report], 4)),
VALUE(MID(cases[Date_report], 4, 2)),
VALUE(LEFT(cases[Date_report], 2))
)

[Maddyqc]

It worked, Thank  you az38-super user II.