AddMonths last 12 months

[q11hhg]

Hi there 

I want to calculate the last 12 months customers by using this formula, but it does not work properly, the result is not correct. I do not know how to fix it, can anyone please help me?  Is this caused by my [Date] column? 

Count(distinct{<Date={">=$(=date(addmonths(Max(Date),-12)))<=$(=date(Max(Date)))"}>}Order_Customer_ID)

[micheledenardi]

The set analysis seems correct.

Can you please post some example data and the expected result?

[q11hhg]

I think something is wrong with my Date, after I adjusted the formula like this, it worked 

Count(distinct{$<Date={">=$(=date(addmonths(Max(Date),-12),'DD/MM/YYYY'))<=$(=date(Max(Date),'DD/MM/YYYY'))"}>}Order_Customer_ID)