Calculate difference vs the previous period

ryan_mayu Thanks for your contribution on this thread.

Hi martaoldi00 ,

I created a sample pbix file(see the attachment), please check if that is what you want. You can update the formula of your measure [_MW Delta] as below:

_MW Delta = 
    VAR Per = SELECTEDVALUE('Upper+Baseline'[Period])
    VAR Prev_Period = Per - 1
    VAR _project=SELECTEDVALUE('Upper+Baseline'[Project Names])
    VAR Actual =
        CALCULATE(
            SUM('Upper+Baseline'[€m]),
            'Upper+Baseline'[Period] = Per
        )
    VAR Previous=
        CALCULATE(
            SUM('Upper+Baseline'[€m]),
            FILTER(ALLSELECTED('Upper+Baseline'),'Upper+Baseline'[Project Names]=_project&&'Upper+Baseline'[Period] =Prev_Period)
        )
    RETURN
          IF(ISBLANK(Previous),BLANK(), Actual - Previous)

Best Regards