12 Replies Latest reply: Jun 3, 2016 3:47 AM by kushal chawda RSS

    Set Analysis

    Nishanthi Rajendran

      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.