Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |