Part of the Dates from my fact table are related to the dates from my Dates Table but not all, why ?

[AlexFromValenci]

Hello community,

I'm trying to connect my fact table with my date table. The two fields that ensure this connection have exactly the same date format in the model view and in Power Query (image below). This connection works for part of the dates, all those from 01/01/2023 onwards, but not for the earlier dates, which is very strange.

How can I make this connection work for all the dates in my fact table?
I don't understand why it works for part of the dates and not all. Either it doesn't work at all, or it works completely.

Thank you very much for your help!
(This problem is driving me crazy haha)
Alex

realtion between the dates table and the fact table

Format of the date field from the dates Table

Format of the date field from the Fact Table

[Dangar332]

Hi, @AlexFromValenci 

Are there any entries in the Accounting_date column of your Fact Table prior to Year 2023?

[AlexFromValenci · Accepted solution]

Hi @Dangar332 
Thanks for your reply!
After multiple checks, I realized that my fact table was connected to a dimension table A, which in turn was connected to a dimension table B. The relationship between these tables A & B was by mistake with a One to One (1:1) cardinality & a cross-filter direction set as both. Sorry for the inconvenience. I hope my case can still help another unfortunate person who makes this error with a large data model...
Have a good day!