Return minimum value for each row

[lucaricci90]

Hello,

I have two tables, joined by case number

1st table

case number	response time
a	10
a	15
a	20
b	5
b	8

2nd table

case number	response time
a	smallest value of first table
b	smallest value of first table

I have tried using the MIN function but it returns the min value of the 1st table regardless the case number. Instead I need it for each case number.

Do you know how to do this?

Thank you!!

[tamerj1 · Accepted solution]

@lucaricci90 
Youy can use

MINX ( RELATEDTABLE ( table1 ), table1[response time] )