Forum Discussion
Find Value in table
Hello, I try to find a value from the table 'Target' in the table 'Value' where the 'Target'[Value T nom] = 'Value'[Value T] and 'Target'[Time] is min. In a second column I need the Value A of th...
Anonymous
And similarly for Target Angle
File attached as well
Target Angle = VAR lookup_value = RELATED ( Target[Value T nom] ) RETURN MINX ( TOPN ( 1, FILTER ( 'Value', [Name] = EARLIER ( [Name] ) && [Value T] = lookup_value ), [Time], ASC ), [Value A] )
Anonymous
And similarly for Target Angle
File attached as well
Target Angle =
VAR lookup_value =
RELATED ( Target[Value T nom] )
RETURN
MINX (
TOPN (
1,
FILTER ( 'Value', [Name] = EARLIER ( [Name] ) && [Value T] = lookup_value ),
[Time], ASC
),
[Value A]
)