Forum Discussion
Display remaining dates in the month with a zero value
Super UserArturo24 , Hope you have selected Jul 2021 in Silcer
0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
Now I have an additional question on returning all dates: The goal was to return ALL dates from first sales to the end of the current month, which we said was 31-Jul.
Situation:
Salesperson A has sales in July , Salesperson B has sales in June. If you filter by salesperson, for person A we see dates all the way through 31-Jul. For person we see sales up through 30-Jun.
Question:
How can I keep the filter on the individual sales person but still return all dates until the end of the month, 31-Jul? For whichever sales person I select how do I return the exact same (entire) date range?
I tried All() but it doesn't work.
Thank you
- Ashish_Mathur
Hi,
To your Table visual, drag Dates from the Calendar Table and write this measure
Total = sum(Data[Sales])
Hope this helps.
