Calculated Measure of values in same column

eblake

You can do it with several slicers and tables as below. We only need to create a column and measure with following DAX formula.

I’ve also upload my .pbix file here for reference.

Date YearMonth = 
FORMAT ( 'Forecasted Data'[Date], "mmmm yyyy" )

Diff = 
CALCULATE (
    SUM ( 'Forecasted Data'[Recognized + Projected Revenue (CAD)] ),
    FILTER (
        'Forecasted Data',
        'Forecasted Data'[Snapshot Date] = MAX ( 'Forecasted Data'[Snapshot Date] )
    )
)
    - CALCULATE (
        SUM ( 'Forecasted Data'[Recognized + Projected Revenue (CAD)] ),
        FILTER (
            'Forecasted Data',
            'Forecasted Data'[Snapshot Date] = MIN ( 'Forecasted Data'[Snapshot Date] )
        )
)

Best Regards,

Herbert