Forum Discussion
Solved
Help with Date/Time Intelligence
I need to know if a process was active within a date period, selected by a Timeline slicer. I have a 4 step process. Each row represents the process, and I have one column for each step completion ...
Mikeincairns
Please try with this measure:
Logic: if the process ended before the "min date selected at the slicer" or the process started after the "max date selected at the slicer" then it returns N otherwise Y.Steps = VAR _MaxSelected = MAXX ( ALLSELECTED ( Calendar), Calendar[Date] ) VAR _MinSelected = MINX ( ALLSELECTED ( Calendar), Calendar[Date] ) RETURN IF ( tblExtract[Step 4] < _MinSelected || tblExtract[Step 1] > _MaxSelected, "N", "Y")I hope this helps, if so please accept as a solution. Kudos are welcome😁.
pcoley
Super User
Super UserMikeincairns
Please try with this measure:
Logic: if the process ended before the "min date selected at the slicer" or the process started after the "max date selected at the slicer" then it returns N otherwise Y.
Steps =
VAR _MaxSelected = MAXX ( ALLSELECTED ( Calendar), Calendar[Date] )
VAR _MinSelected = MINX ( ALLSELECTED ( Calendar), Calendar[Date] )
RETURN
IF ( tblExtract[Step 4] < _MinSelected || tblExtract[Step 1] > _MaxSelected,
"N", "Y")I hope this helps, if so please accept as a solution. Kudos are welcome😁.