Transfer from last WEEK / Carry over - throws error with circular reference

[PeterElbek]

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]

[Greg_Deckler]

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

[PeterElbek]

Forgot to attach the last time. Here goes.

[PeterElbek · Accepted solution]

Ended up using advice from this solution: https://community.powerbi.com/t5/Desktop/Circular-reference-calculation/td-p/213415