=NP("Formula";"=DATE(CONCATENATE(20;LEFT(1801000;2));RIGHT(LEFT(1801000;4);2);1)")
This would result in a date 1-01-2018.
Now I would like to format that date to show as 18-01 in the table. I still need it usable as a date so using =text() is not an option. Because then it would see 18-01 as just a number which is not usable for PowerPivot and the data model.
Any suggestions?