Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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] )
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] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |