Date format dd.mm.yyyy problem

[ARoldanPBI]

Hey guys, I need the format dd.mm.yyyy as date but it only has dd.mm.yy, if i use a text field to generate dd.mm.yyyy i cant order as i would want because the field isn't date, someone can help me? Thanks!

[amitchandak]

You can create another date field on this using

Combine = mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)

But try if using Data type and format. Is this detected as the date.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[ARoldanPBI]

I keep having the same error, The value 'dd.mm.yyyy' isn't able to convert from Type Text to Type Date. @amitchandak

[amitchandak]

Can you create a new date column like suggested

Combine = mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)

use that for sort or has the main date

[ARoldanPBI]

I cant use dd/mm/yyyy i need "." not "/" and with "." i cant convert to date @amitchandak