Forum Discussion

Maddyqc's avatar
Maddyqc
Frequent Visitor
6 years ago
Solved

Not able to convert text to date

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 ...
Need Help
  • az38's avatar
    az38
    6 years ago

    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's avatar
    az38
    6 years ago

    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))
)
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Maddyqc
Frequent Visitor
6 years ago

It worked, Thank  you az38-super user II.