Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AlexFromValenci
Regular Visitor

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

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

AlexFromValenci_0-1722766951213.png

 
 
 

realtion between the dates table and the fact tablerealtion between the dates table and the fact table

 

Format of the date field from the dates TableFormat of the date field from the dates Table

 

Format of the date field from the Fact TableFormat of the date field from the Fact Table

 

 

1 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!

View solution in original post

2 REPLIES 2
Dangar332
Super User
Super User

Hi, @AlexFromValenci 

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

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!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.