Forum Discussion
summer18
Helper III
Helper IIICircular dependency error with Prior Month
I have a formula but getting "circular dependency error" that points to Prior Month budget but my formula is for Sales Actual. Formula with error: IF('Sales'[Department]="IT",0,'Sales'[YoY]) ...
I'm assuming that the formula you state is for a calculated column?
If so have a read of Avoiding circular dependency errors in DAX - SQLBI.
In the expression for the calculated column you want to wrap your [YoY] measure inside a calculate with an ALLEXCEPT to prevent it from adding everthing into the filter context.
bcdobbs
Community Champion
Community ChampionI'm assuming that the formula you state is for a calculated column?
If so have a read of Avoiding circular dependency errors in DAX - SQLBI.
In the expression for the calculated column you want to wrap your [YoY] measure inside a calculate with an ALLEXCEPT to prevent it from adding everthing into the filter context.