Sum Sales for previous 12 months

[alec1982]

Hi guys,

Anybody can help me on why this is not working. I am trying to get the sales for the last 12 months.

Num(sum({$<[Date]={'>=$(=AddMonths(Today(),-12)'}>}[Sales]),'#,##0')

Thxs,

Alec

[Gysbert_Wassenaar · Accepted solution]

It's missing a ')' to close the AddMonths function:

Num(sum({$<[Date]={'>=$(=AddMonths(Today(),-12))'}>}[Sales]),'#,##0')

[alec1982]

Thxs sir!