Date coversion

[Anonymous]

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?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Have a try:)

[RobbeVL]

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

[Anonymous]

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.