Century date format to current date format

[Aruna_ln]

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

[v-yuezhe-msft]

@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

[Aruna_ln]

Thanks You but ineed data type is Date

[v-yuezhe-msft · Accepted solution]

@Aruna_ln,

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



Regards,
Lydia