Look Up Expression No Return Value

Hi All,
Why I can’t get any result in this expression:
LOOKUP([_THISROW].[Materials],“HW Products”,“Product Name”, “Price”)

Return Zero

My Product Table:

thanks

Try to remove [_THISROW] and see if you can get the result. Did you place the expression in the initial value of the Unit-Cost column?

1 Like

I tried it without the [_thisrow]. doesn’t work.
it is in initial value of Unit Cost.

I even used Any and select still no result. no error

Maybe you wish to try, assuming [Materials] is a reference column that references ,“HW Products” table,

LOOKUP([_THISROW].[Materials],“HW Products”,“Product Key”, “Price”)

Or if the table “HW Products” is referenced in the table where the form picture you have shared is based of, you may wish to also try

[Materials].[Price]

2 Likes

awesome Suvrutt!,
thanks.
this [Materials].[Price] does the trick

2 Likes

Good to know it works. You may wish to take a look at the following article

2 Likes

will do. thanks

1 Like