Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date coversion

Hi,

 

I would appreciate some assistance. 

 

My actual date is 01/07/19 but Power BI converted this date to 2001/07/19.

 

How do I fix this?

Need Help

3 Replies

  • RobbeVL's avatar
    RobbeVL
    Impactful Individual
    7 years ago

    In PowerQuery, just change data type to Date, it will do this automatically.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the reply.

       

      I have tried that, I had success converting some columns, but not others. I get the dates in my original post.