Date Add missing a month always

[Lobs]

Hi, 

So im trying to get the previous month HC data per month, but i keep on missing December as seen below. All the other months align perfectly, am i missing something?

I have a measure setup - 

Previous Month HC = calculate(sum('Retention Local 2'[HC_Cur_Mo]),dateadd('Retention Local 2'[Month],-1,MONTH))

[Samarth_18 · Accepted solution]

Hi @Lobs ,

Try to use date table in the dateadd.

Previous Month HC =
CALCULATE (
    SUM ( 'Retention Local 2'[HC_Cur_Mo] ),
    DATEADD ( 'calender_table'[date], -1, MONTH )
)

Thanks,

Samarth

[Lobs]

thank you this worked, just linked my calendar and updated the views, all good now