Forum Discussion

ARoldanPBI's avatar
ARoldanPBI
Frequent Visitor
6 years ago

Date format dd.mm.yyyy problem

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? T...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
    ARoldanPBI
    Frequent Visitor
    6 years ago

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

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      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's avatar
        ARoldanPBI
        Frequent Visitor
        6 years ago

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