Hi All,
I have the supposed answer but the row does not provide the answer.
Tried both expressions of the INITIAL VALUE for the [Unit Cost column]:
-
Any (Select(HW Products[Price],[Product Name]=[_thisrow].[Materials]))
-
Lookup(“Materials”,“HW Products”,“Product Name”,“Price”)
HW Table:

Result:
App setup:

