Find Value in table

[Anonymous]

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

[Zubair_Muhammad]

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]
    )

[Zubair_Muhammad · Accepted solution]

@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]

@Zubair_Muhammad

Very good, thank you !