Last 12 Months

[#1]

hello ,

I managed to set up the set analysis expression  that generates the sum of the rolling 12-month from MAX  the month loaded data.

But the problem is that by selecting one/many month (MMMYYYY) of the selection list, it takes maximum months slected as the reference !!

Set analysis expression is :

=sum({<[MARQUE]={'BMW'},YYYY= ,MMM= ,MMMYYYY=,[MMMYYYY]={'>=$(=AddMonths(max([MMMYYYY]),-11))'}>

+<[PW]={'286'},YYYY= ,MMM= ,MMMYYYY= ,[MMMYYYY]={'>=$(=AddMonths(max([MMMYYYY]),-11))'}> Sales)

thanks .

[sunny_talwar · Accepted solution]

Try this:

=Sum({<[MARQUE]={'BMW'},YYYY= ,MMM= ,MMMYYYY=,[MMMYYYY]={'>=$(=AddMonths(Max({1}[MMMYYYY]),-11))'}>

+<[PW]={'286'},YYYY= ,MMM= ,MMMYYYY= ,[MMMYYYY]={'>=$(=AddMonths(Max({1}[MMMYYYY]),-11))'}>Sales)

[#3]

Thanks Sunny . It works