Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Ranking

Part Date time Before After DESIRED RESULT a 1/1/2022 9:00:00 AM   0.1 0 a 1/1/2022 9:15:00 AM 0.1 0.7 0 a 1/1/2022 11:00:00 AM 0.7 0.3 0 a 1/1/2022 3:00:00 PM 0...
ranking
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Maybe:

    DESIRED RESULT column =
  VAR __Part = [Part]
  VAR __Date = [Date]
  VAR __time = [time]
  VAR __MaxDate = MAXX(FILTER('Table',[Part] = __Part),[Date])
  VAR __MaxTime = MAXX(FILTER('Table',[Part] = __Part && [Date] = __MaxDate),[time])
RETURN
  IF([Part] = __Part && [Date] = __Date && [time] = __time,1,0)
Swilson2112's avatar
Swilson2112
Frequent Visitor
4 years ago

I figured this part out.  Now I am trying to create a measure that compares the invoice date from table 1 with the closest lower Change date from table 2 and then returns the changed field from table 2.