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 this line. And that for each group (column name).
I hope the picture helps you to understand what I mean. The green columns are the one that I need.
Best regards
Timo
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] )
3 Replies
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] )