Forum Discussion

JonathanJohns's avatar
JonathanJohns
Helper III
8 years ago

Data 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...
Need Help
JonathanJohns's avatar
JonathanJohns
Helper III
8 years ago

I give you an example of my data. In fact, there is only two days :

- 16/11/17

- 21/11/17

 

DATE
17/11/2016
17/11/2016
17/11/2021
17/11/2021
17/11/2016
17/11/2016
17/11/2021
17/11/2021
17/11/2016
17/11/2016
17/11/2021
17/11/2021
17/11/2016
17/11/2016
17/11/2021
17/11/2021

 

 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi JonathanJohns,

 

Could you try the formula below to see if it works? :smileyhappy:

MyDate = 
DATE ( 2000+ VALUE ( RIGHT( '25sqsyn'[DATE], 2 ) ), MID ( '25sqsyn'[DATE], 4, 2 ), LEFT( '25sqsyn'[DATE], 2 ) )

 

Regards

  • JonathanJohns's avatar
    JonathanJohns
    Helper III
    8 years ago

    I've got the same error. I show you how my data are. I don't see where the problem could come. This is a view from the editor.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    So, is that format, dd/mm/yyyy?