Forum Discussion
Community ChampionHelp with WoW result
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. Any help would be highlighly appreciated.
Spend | Week | Date | Expected Result |
120 | 1 | 01-Jan-23 |
|
130 | 2 | 02-Jan-23 | 120 |
150 | 2 | 03-Jan-23 | 130 |
120 | 2 | 04-Jan-23 | 150 |
110 | 2 | 05-Jan-23 | 120 |
90 | 2 | 06-Jan-23 | 110 |
56 | 2 | 07-Jan-23 | 90 |
58 | 2 | 08-Jan-23 | 56 |
36 | 3 | 09-Jan-23 | 58 |
90 | 3 | 10-Jan-23 | 36 |
120 | 40 | 01-Oct-22 | 0 |
230 | 40 | 02-Oct-22 | 120 |
220 | 41 | 03-Oct-22 | 230 |
100 | 41 | 04-Oct-22 | 220 |
Hi,
you need to add a Year column in your Table
Year = YEAR('Table'[Date])then you can use offsetMeasure = CALCULATE(Sum('Table'[Spend]),OFFSET(-1,ORDERBY('Table'[Date],DESC),,PARTITIONBY('Table'[Year])))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!
2 Replies
- serpiva64
Solution Sage
Hi,
you need to add a Year column in your Table
Year = YEAR('Table'[Date])then you can use offsetMeasure = CALCULATE(Sum('Table'[Spend]),OFFSET(-1,ORDERBY('Table'[Date],DESC),,PARTITIONBY('Table'[Year])))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!
