Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
do one thing ,
Create a variable for selected period
like in same format ,
count({1<Month_Year-={$(v_Variable)},[Derived Demand Status]={'Open','Coverage External'}>}[Resource Request Id])
WHATS THE DIFFERENCE?
please see now my post
variable is not a problem it is to exclude the selected and foregoing months
Are you need to bypass the month selection?
try this
count({1<Month_Year=e({1<Month_Year={">=$(=date(max(Month_Year),'MMM-YYYY'))<=$(=date(addmonths(max(Month_Year),1),'MMM-YYYY'))"}>}Month_Year),[Derived Demand Status]={'Open','Coverage External'}>}[Resource Request Id])
s
You don't need the variable, but you do need a static value and a -= to do the exclude.
Is Month_Year a text field, or is it a numeric QV date field?
I assume that current month can be based on Today().
Something like:
count({1<Month_Year-={"$(=Date(Today(), 'MMM-yyyy'))"},[Derived Demand Status]={'Open','Coverage External'}>}[Resource Request Id])
It worked thanks a lot... will it work without selection for example if we include the Month_Year in the dimension will the data will be populated automatically?