Calculate Function with DATEADD and Filter not working

[dw2468]

I have the code for current month, which works well for me. However if I check the DATEADD to -1, the current month row data doesn't show the previous month value in the table visual. Any idea why?

CurrM = CALCULATE(
    SUM('CADUSD'[Balance]),
    FILTER(
        'CADUSD', 'CADUSD'[Data Type] <> "Plan"
    ),
    DATEADD(
        Calendar[Date], 0, MONTH
    )
)


PrevM = CALCULATE(
    SUM('CADUSD'[Balance]),
    FILTER(
        'CADUSD', 'CADUSD'[Data Type] <> "Plan"
    ),
    DATEADD(
        Calendar[Date], -1, MONTH
    )
)

[ray_aramburo]

See my example attached on how to set up the measures, you can adjust as needed:

I used a similar structure of yours but changed my totals just to serve as an example.

[ray_aramburo]

You are filtering your data for February so in the filter context there's nothing to be shown for January but it appears since you included a Previous Month value as well. For Current Month you should remove the DateAdd portion of the measure, it is not needed.

[dw2468]

if I remove the months filter, the CurrM column now has more than 1 values. I should expect CurrM to only show only the february number when i have DATEADD, 0, MONTH (see image attached)

[dw2468]

not sure why i did the same in my model and it wouldn't work. the result is the same as per my original screenshot.

[ray_aramburo]

Why would you need the Data Type column filter on the measure but then add it to the visual?