Forum Discussion
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,
(ISBL...
Anonymous , Please refer to my HR blog, This can help to find active between 2 dates
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.