Forum Discussion
Helper IIIData Format in Power BI
Good afternoon,
I've got a problem when I use my database in Power BI with the date.
The format date is like that in my database :
"17/11/16"
"17/11/21"
So the format is : Year/Month/Day
But when I use this database in Power BI, the sotware read it like that : Day/Month/Year
So the date 17/11/21 which means the 21 november 2017 becomes the 17 november 2021.
I don't find the way to change that. I have tried to change the format of the date but the structure is always wrong.
Do you have any ideas to change it please ?
Thanks for your help.
12 Replies
- Greg_Deckler
Community Champion
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))
JonathanJohnsHi 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.
- Greg_Deckler
Probably use something like a FORMAT or use the predefined format options under the modeling tab.
Column = FORMAT([Date],"mm/dd/yyyy")
