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

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