Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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))
)
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))
)
Thank you, Super User II
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?
It worked, Thank you az38-super user II.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |