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.
Fowmy
Super User
Super UserAnonymous
Prior to doing the matching, check the Data Types of both the fields and change it to Date if required.
Also, check if there are matching dates exist in both tables.
Hope you are using the correct join type
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š