Max Value from Previous Week

Hi Caz_16 ,

If you want to calculate the cases between current week and last week which based on current week, you can try this measure:

Change by week =
VAR _Week =
    WEEKNUM ( TODAY (), 2 )
VAR thisweeknumber =
    CALCULATE (
        SUM ( 'VDH-COVID-19-PublicUseDataset-Cases'[Total Cases] ),
        'VDH-COVID-19-PublicUseDataset-Cases'[Week Number] = _Week
    )
VAR lastweeknumber =
    CALCULATE (
        SUM ( 'VDH-COVID-19-PublicUseDataset-Cases'[Total Cases] ),
        'VDH-COVID-19-PublicUseDataset-Cases'[Week Number] = _Week - 1
    )
RETURN
    thisweeknumber - lastweeknumber

Based on your dataset, it will get the result like this:

Best Regards,
Yingjie Li

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