Forum Discussion

Aruna_ln's avatar
Aruna_ln
Helper III
8 years ago
Solved

Century date format to current date format

Hi My date format centure date(7 numbers)

example:1170228

left to right:first number is centure1 for 20,0 for 19

then two digit is years mean 197 mean 2017 years

then 02 mean MM

then 28 is DD

 

I need date format 2017/02/28

 

Please any help on DAX formal or any Power Bi date format option availble 

 

Thanks

Aruna

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Aruna_ln,

    You can change the data type of the Date column to Date.



    Regards,
    Lydia

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Aruna_ln,

    Create the following columns in your table.

    Column = IF(LEFT(Table[Column1],1)="0","19","20")

     

    Date = Table[Column]&MID(Table[Column1],2,2) &"/"& MID(Table[Column1],4,2) &"/" &RIGHT(Table[Column1],2)



    Regards,
    Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Aruna_ln,

        You can change the data type of the Date column to Date.



        Regards,
        Lydia