Forum Discussion
USERELATION error due to circular dependency
I have the following formula that gives me an error for circular dependency. Does anyone know a solution. Essentially I have the issue of having two date columns in the Timing Plan table, one for target date and one for actual date [Supplier RFQ Sent Out Completion Date] that I am trying to map to the Schedule table [Date column]. Since the active relationship is done with the actual date column [Supplier RFQ Sent Out Completion Date], I had decided to do an inactive relationship and use userelationship with the target date column. Ultimately I would like to be able to use some other columns in the timing plan table as filters with a slicer.
If anyone knows a work around with userelation or any other ideas, I would appreciate it
1 Reply
- amitchandakSuper User
emrei , I think the bi-directional join might be causing it. Make all 1-Many joins in the schema as single directional and try