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:
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |