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.
PC2790
Community Champion
Community ChampionCan you try and make the format of both the columns same and see if that works?