Forum Discussion

Mikeincairns's avatar
Mikeincairns
Frequent Visitor
1 year ago
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 ...
  • pcoley's avatar
    pcoley
    1 year ago

    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's avatar
pcoley
Super User
1 year ago

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😁.

  • Mikeincairns's avatar
    Mikeincairns
    Frequent Visitor
    1 year ago

    Thanks for getting me in the right direction.
    I am finding it super hard to describe what I want, so dont want to waste anyones time.
    I will mark it as solved.
    Appreciate your reply veru much,  Thankyou.