Dated If Formula with multiple conditions

[Anonymous]

Hi All,

Hope everyone is doing well.
I need some more help with a formula please 🙂

Find the # of Days between Start Date and First Open Time with the criteria of:

1. Answer = Accept
2. Status <> Void

3. First Open Time after Start Date

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

Measure = 
  VAR __Name = MAX('Table'[Name]
  VAR __Start = MAX('Table'[Start Date])
  VAR __OpenTime = MINX(FILTER(ALL('Table'), [Name] = __Name && [Status] = "Active" && [Open Time] > __Start), [Open Time])
  VAR __Result = ( __OpenTime - __Start ) * 1.
RETURN
  __Result