Dax Actual Profit & Loss v Monthly Forecast Variance

[EnterpriseDNA]

Hi @Suzie, please check this post if it applies to your situation and desired outcome.

Hope it helps.

Calculate values prior to the current month - DAX Calculations - Enterprise DNA Forum