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? Thanks!

Need Help

4 Replies

  • 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