Forum Discussion
Anonymous
5 years agoNot applicable
Date Measure Graphing Issue
When I use this measure:
Open MOCs =
VAR Currentdate = MAX(Dates[Date])
VAR ActiveMOCs =
CALCULATE(
DISTINCTCOUNT(data[MOC Number]),
ALL(Dates),
Dates[Date]<=Currentdate,
(ISBLANK(data[Close Date]) && ISBLANK(data[Cancelled Date]))
||data[Close Date]>=Currentdate
||data[Cancelled Date]>=Currentdate
)
Return
ActiveMOCs
I get the right result, but when I make a line graph (using the measure above and year/month) and filter to dates from the last year, then a get results that are much smaller than I expect.
Any idea what I am doing wrong?
2 Replies
- amitchandakSuper User
Anonymous , Please refer to my HR blog, This can help to find active between 2 dates
- AnonymousNot applicable
I am able to find the number active, the issue is when I want to graph it and only see the last year. Once I apply that filter it's applying it to all the dates and then my numbers are off.