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)) Transa...
Ended up using advice from this solution: https://community.powerbi.com/t5/Desktop/Circular-reference-calculation/td-p/213415
Greg_Deckler
Community Champion
Community ChampionRight, 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