Forum Discussion
Solved
Transfer from last WEEK / Carry over - throws error with circular reference
Putting together a simple matrix with the following measures per week:
Transfer from last week = CALCULATE([End of week];FILTER(ALL(Dato);Dato[WeekYearSort]=MAX(Dato[WeekYearSort])-1))
Transactions = CALCULATE(SUM(Cashflow[Likv. indv]);FILTER(Cashflow;Cashflow[Likv. type]="IK"))
End of week = [Transactions]
So far so good, but obviouly I want End of week to include Transfer from last week, but if I change to the below it throws an error complaining about a circular reference. I have absolutely no idea on how to fix this.
End of week = [Transfer from last week] + [Transactions]
Ended up using advice from this solution: https://community.powerbi.com/t5/Desktop/Circular-reference-calculation/td-p/213415
3 Replies
- Greg_Deckler
Community Champion
Right, the problem is highlighted below:
Transfer from last week = CALCULATE([End of week];FILTER(ALL(Dato);Dato[WeekYearSort]=MAX(Dato[WeekYearSort])-1))Transactions = CALCULATE(SUM(Cashflow[Likv. indv]);FILTER(Cashflow;Cashflow[Likv. type]="IK"))End of week = [Transactions]Tough to say how to fix it. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Forgot to attach the last time. Here goes.
Ended up using advice from this solution: https://community.powerbi.com/t5/Desktop/Circular-reference-calculation/td-p/213415
