Calculate Actual spend from a cumulative spend

[Jendeep]

How to create dax measure 'actual spend' for that month when I have cumulative spend amount value for month on month. Please help.

I tried something like this

ActualSpend = CALCULATE([Spend To Date]-CALCULATE([Spend To Date],PREVIOUSMONTH('dates table'[Date].[Date])),VALUES (' dates table'[Date].[Date]))

but it gives me the same value as the Spend To Date. 

[Spend To Date] is a measure that calculates the sum(costactualspent)

what am I missing? 

[Gengar]

Hi @Jendeep ,

Please try something like this:

ActualSpend =
VAR _previous =
    CALCULATE (
        [Spend To Date],
        FILTER (
            ALL ( 'dates table' ),
            [Date] <= EOMONTH ( MAX ( 'dates table'[Date] ), -1 )
        )
    )
RETURN
    [Spend To Date] - _previous

Best regards,

Gengar

[Jendeep]

Hi,

I applied your formulae to calculate the actual spend for that month. It is appearing as below.