Forum Discussion
Circular Dependancy when creating Relationship
I have various tables with dates and I am able to create relationships on dates to my calendar table all but one of the tables where I presented with a circular dependancy message. I am unable to see why there would be a circular reference as the two tables are not linked in any calculated colums etc and I have been able to connect to other tables in the exact same scenario.
Here is the error message
Here is my data model
I've been scratching my head for days now and would appreciate any help/guidance from the community. Thanks in advance.
To demo...
exactly the same model...
7 Replies
How is your date table built? Suspect you may be using CALENDARAUTO?
Hi Ben, yes I am using CalendarAuto as I have several tables with dates that I need to use and didn't know how to get to a min and max date across various tables. I thought CalendarAuto might be causing this issue but not sure how to correct. Any ideas? Thanks
It's worth trying the folowing. When you create the relationship drag from the fact table (many side) into the date table. I think you'll find it works! I know I've had that issue before but now trying in latest version of Power BI I can't recreate the problem at all and it works both ways round.
However I tend to avoid using CALENDARAUTO and go for this sort of approach...
Date = VAR EarliestYear = YEAR ( MIN ( Purchases[Date] ) ) VAR LatestYear = YEAR ( MAX ( Purchases[Date] ) ) RETURN ADDCOLUMNS ( CALENDAR ( DATE ( EarliestYear, 1, 1 ), DATE ( LatestYear, 12, 31 ) ), "Month Year", DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 ) //Format as mmm YYYY )
