Forum Discussion
Solved
Problem with circular dependency in two tables
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/...
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
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