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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.