Merging Date To Date fields fail in Power Query

[Richard_Halsall]

Hi

I have 2 tables with a week ending date, of type date, I am trying to merge but get this error

Both fields are of
- type date and clean
- column quality of both is 100%

I have tried

- duplicating the Dates table and merging but get the same error

- used Date.From([WeekEnding]) from the WeeklyExchangeRates table and merging but get the same error

However interestingly the tables will merge on the Dates[Date] column but shouldn't I be able to merge a 'many to many' field with a 'many to many' field???

I would appreciate any suggestions. Thanks

[edhans · Accepted solution]

It is merging, it is just saying that no dates in the 27 records of the first table exist in the second table. Have you validated that records exist to match?

Also, can you confirm the culture is the same? For example. in the first table, those could be June 11 or Nov 6, depending on the culture, and that won't match as expected. Make sure they are set tot he same. You can do that by forcing the culture when you change the data type.