Forum Discussion
Wrong Matching between two column date
Hello, I have a problem between my calendar table and another table. The join between my date column from the calendar and the date column from the other table is failing to match. There is no date m...
I ended up finding the solution. In power query these famous columns were originally in text format. They were then changed to date time type. By modifying again from the query editor to the simple date format. It works ! Note that changing the format outside of power query did not solve the problem.
I ended up finding the solution. In power query these famous columns were originally in text format. They were then changed to date time type. By modifying again from the query editor to the simple date format. It works ! Note that changing the format outside of power query did not solve the problem.