Forum Discussion
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...
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)
Thanks Greg. This worked.