Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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!
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!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
98 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
120 | |
73 | |
72 | |
63 |