Current week vs last week sum

Hi, I have a dataset containing week numbers and sales figures associated to each week, along with other columns such as market, product etc. How would do I create a measure to compare the sa...

Need Help

Anonymous

7 years ago

Hi bo_afk ,

You can add allselected function to get current last week number and use it to find out correspond amount:

CW Sales =
VAR CW =
    CALCULATE ( MAX ( Table[WeekNum] ), ALLSELECTED ( Table ) )
RETURN
    CALCULATE (
        SUM ( Table[Sales] ),
        FILTER ( ALLSELECTED ( Table ), Table[WeekNum] = CW )
    )

Regards,

Xiaoxin Sheng

Forum Discussion

Current week vs last week sum

Related content

Week over week measure

ISO week

Week over Week Diff

Week over Week Change

Utiisation per week