Set Analysis

[nishanthi_8]

count({1<Month_Year=e(Month_Year),[Derived Demand Status]={'Open','Coverage External'}>}[Resource Request Id])

Here it excludes the current month. But I need to exclude the following month also and it is in the format of 'MMM-YYYY'. Suppose for example :

If  I select 'Feb-2016' it should exclude 'Feb-2016' and the following months also. How can it be achieved.

[Kushal_Chawda]

No, I think. Because set analysis works only once per chart not per dimension value

[nishanthi_8]

and one more help in that scenaio suppose if i want to include the selected month and previous months and exclude the foregoing months

for example if it is JAN 2016 it should consider nov,dec 2015,jan2016 but not feb,march 2016

[Kushal_Chawda]

count({1<Month_Year=e({1<Month_Year={">=$(=date(addmonths(max(Month_Year),-2),'MMM-YYYY'))<=$(=date(max(Month_Year),'MMM-YYYY'))"}>}Month_Year),[Derived Demand Status]={'Open','Coverage External'}>}[Resource Request Id])