Help with WoW result

[Uzi2019]

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

[serpiva64 · Accepted solution]

Hi,

you need to add a Year column in your Table

Year = YEAR('Table'[Date])

then you can use offset

Measure = 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!

[Uzi2019]

@serpiva64  Thanks a ton! you saved me again 😊