Forum Discussion
Gianluigi
3 years agoHelper II
format Date
HI, I import a csv file 02/10/2023;10/10/2023 31/12/2023;02/01/2024 04/05/2023;01/06/2023 10/03/2021;10/04/2021 power bi recognizes the date ( dd/mm/yyy Italian) by importing it correctl...
vicky_
3 years agoSuper User
You can use FORMAT([date], "dd/mm/yyy") to force it to display in a certain format. Other than that, check that your local pc (windows) settings are using the correct date format, or take a look at the Power BI settings under File > Options > Regional Settings (both Global and Current File).
Gianluigi
3 years agoHelper II
Hi,
the settings seem correct