Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I have two tables as follow:
Table: Calendar
Column: "Date" which contains a formula "Calendar = CALENDARAUTO(3)"
Table: UK holiday
Date | is_working_day |
01/04/2018 | 0 |
02/04/2018 | 0 |
03/04/2018 | 1 |
04/04/2018 | 1 |
05/04/2018 | 1 |
06/04/2018 | 1 |
07/04/2018 | 0 |
08/04/2018 | 0 |
09/04/2018 | 1 |
When I try to create a relationship and link by Date in both tables, I have a circular dependency problem. Is there a way to fix that?
Thanks,
Ricky
Solved! Go to Solution.
I've seen that circular dependency error before. When creating the relationship, select the UK Holiday table first (top of the relationship), and select the calculated Calendar table second.
Here's a pbix file with your sample data and the relationship created:
https://github.com/ssugar/PowerBICommunity/raw/master/community-sol-264607.pbix
Yup, it looks like it might be. It seems to occur whenever I try to create a relationship with a calculated table on top.
Cheers,
Scott
I've seen that circular dependency error before. When creating the relationship, select the UK Holiday table first (top of the relationship), and select the calculated Calendar table second.
Here's a pbix file with your sample data and the relationship created:
https://github.com/ssugar/PowerBICommunity/raw/master/community-sol-264607.pbix
User | Count |
---|---|
141 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |