Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to change the text data type to date datatype

hi all,

 

my date is currently in text data type its like Mar'24 .i need to convert it to date datatype in power bi. please help me asap.

Need Help
Show and Tell
Tutorial Requests
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Anonymous ,

     

    Replace the ' (single quotation) by a / (solidus) then just convert to date format

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous ,

     

    Replace the ' (single quotation) by a / (solidus) then just convert to date format

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      in format should i give mmm/yy?

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        Hi Anonymous ,

         

        After doing the query change you can format in desktop to be mmm/yy