DB functions based on values of a different table

[monedero]

I want to display in a field or a purchase table the minimum price per unit of an article taken from a different table where each article appears many times with different prices per unit. Any hint on the expression I need to use?

[SkrOYC]

What have you done so far?

[Marc_Dillon]

help.appsheet.com

MIN()

Lowest item in list

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[monedero]

I understand the need to use MIN and SELECT but I don’t get the required syntax:
MIN(SELECT(Purchases[Unitprice], Purchases[Itemname]=Itemname]))
Is this approch correct to insert as a field formula in the field [Minimum price] of the table (Competitive list)?

[Marc_Dillon]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…