Calculate this week sales vs last week

[joshua1990]

Hi all!

I have built a simple measure that shows me the difference between the sales for this week compared to previous week.

CW vs LW = 
VAR _CW =
    SELECTEDVALUE ( 'Calendar'[WeekOffset] )
VAR _LW =
    SELECTEDVALUE ( 'Calendar'[WeekOffset] ) - 1
RETURN
    CALCULATE (
        [Sales],
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[WeekOffset] = _CW )
    )
        - CALCULATE (
            [Sales],
            FILTER ( ALL ( 'Calendar' ), 'Calendar'[WeekOffset] = _LW )
        )

Actually, this measure works for 2weeks ago vs 3weeks ago.

But If I want to compare current week with previous week, then it doesn't work.

And I am not able to get the issue.

Is there someone who could share a different approach to get this comparison / number?

Best regards

Joshua

[v-xiaosun-msft]

Hi @joshua1990 ,

Has your problem been solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@joshua1990 Maybe:

CW vs LW = 
VAR _CW = MAXX(FILTER( 'Calendar', [Date] = TODAY()), [WeekOffset])
VAR _LW = _CW - 1
RETURN
    CALCULATE (
        [Sales],
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[WeekOffset] = _CW )
    )
        - CALCULATE (
            [Sales],
            FILTER ( ALL ( 'Calendar' ), 'Calendar'[WeekOffset] = _LW )
        )