Forum Discussion
Solved
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 se...
To demo...
exactly the same model...
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
)
Hi Ben, that is the approach I tried before but with so many dates in tables - all of which are relevant and with some being previous to my main table (main date field), so using min/max on the date field meant my calendar didn't have those earlier dates when having to reference the data for that using calendar table.