Forum Discussion
Uzi2019
Community Champion
Community ChampionIncorrect Prev week value
Hi Community, I need to calculate prev week spend which I tried from my end but at the measure total getting wrong result. Attaching sample data and screen shot below: Spend Date 120 1-Jan-...
Hi,
try a measure like this
Measure = CALCULATE(sum('Table (2)'[Spend]), OFFSET(-1,ALLSELECTED('Invoked Function'[ISOWeekID])))If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
serpiva64
Solution Sage
Solution SageHi,
try a measure like this
Measure = CALCULATE(sum('Table (2)'[Spend]), OFFSET(-1,ALLSELECTED('Invoked Function'[ISOWeekID])))
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
