Forum Discussion
Data Format in Power BI
Might be a regional settings issue.
You could always try to import it as text and then create a column using DATEVALUE that parses out the date parts, like:
MyDate = DATE(LEFT([column],2),MID([column],4,2),RIGHT([column],2))
Hi smoupre,
Thank you for your answer. I tried almost all the regional settings but I didn't find the solution. I tried your calculation and it works thank you. Just one thing, when I get the format with my date, I have something like that :
"21/10/17"
If I want to have all the year, the software doesn't write 21/10/2017 but 21/10/1917. Do you know a way to transform it please ?
Thanks a lot for the calculation.
Probably use something like a FORMAT or use the predefined format options under the modeling tab.
Column = FORMAT([Date],"mm/dd/yyyy")
If I change the format, it will change only the structure of the date but not the value of it. Moreover, using the function format gives me a date like a texte and not like a date. I am trying to change a little bit your calculation but I don't find how get the good structure now.
How about:
MyDate = DATE(2000+VALUE(LEFT([column],2)),MID([column],4,2),RIGHT([column],2))