Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power Query convert text to date

Hi,   You know how excel transforms date to text for example: 8/07/2019 to 43654   In my Power BI report, I have a text column that store values differently example below: WEEK 1/07/2019 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

The screenshots should say it all.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Ashish_Mathur  ,

    Can you please try that on the Power BI Query Editor and let me know if that works for you?


    As I followed your steps and I am still getting a DateFormat Error.

     

    Thanks 
    Robin

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      You are right.  It is not working for the 2 cells which carry numbers.  Sorry, do not know what to do in PBI desktop.