Forum Discussion
PeterElbek
6 years agoFrequent Visitor
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...
- 6 years ago
Ended up using advice from this solution: https://community.powerbi.com/t5/Desktop/Circular-reference-calculation/td-p/213415
PeterElbek
6 years agoFrequent Visitor
Forgot to attach the last time. Here goes.
PeterElbek
6 years agoFrequent Visitor
Ended up using advice from this solution: https://community.powerbi.com/t5/Desktop/Circular-reference-calculation/td-p/213415