Forum Discussion
Ranking
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)
EXAMPLE of tables and desired result.
TABLE 1
Transaction #. Part# Invoice Date.
1. A 02/14/2022
2. A 02/02/2022
TABLE 2
Part# Chnage Date. Change
A. 02/10/2022. 1.25
A 02/05/2022 0.37
A 01/15/2022 2.56
Desired Resultes
Transaction Return Result. Notes:
1 1.25 Chnage date of 02/10/2022 is closest less than date from invoice date of 02/14/2022
2 2.56 Chnage date of 01/15/2022 is closest less than date from invoice date of 02/02/2022