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] )
HI Timo Anonymous
Assuming above table are related by Name field,
Try the calc column
Target Time =
VAR lookup_value =
RELATED ( Target[Value T nom] )
RETURN
MINX (
TOPN (
1,
FILTER ( 'Value', [Name] = EARLIER ( [Name] ) && [Value T] = lookup_value ),
[Time], ASC
),
[Time]
)
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] )