DAX: 12 month rolling with blanks

[Anonymous]

Hi,

I am not proficient user in DAX so I ask your support.

I calculated the 12M as follows:

12MR = calculate(
sum(Sales[Or Sales Eur]);
datesinperiod(Calendar[YMD];lastdate(Calendar[YMD]);-12;MONTH)
)

Basically it works well but if I divide the data in categories, if one category is zero in a specific month (so it is blank), the 12M calculation gets me zero instead of the sum of the previous 12 months. Could you help me? Thanks

[Anonymous]

That's pretty much impossible. It looks like you just don't have any sales in the last 12 months for the months that report 0.