Forum Discussion
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])
Here are the formulas related to my measure above:
YoY formula = (SUM(Actual)-[PY Actual]) / [PY Actual])
How can I fix the error?
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.
1 Reply
- bcdobbs
Community Champion
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.