PowerPivot : LOOKUPVALUE

[AndyMax]

Hi

I have problem with the lookupvalue.

=LOOKUPVALUE(Status;number;[Supplier no.])

Column status contains multiple rows with YES or NO.

I get following message.

A table of multiple values was supplied where a single value was expected.

Anyone who can help me out?

Br Andy

 

[Matt Allington]

Are you writing this as a calculated column or a measure? You can't write it as a measure unless it is inside a function that has a row context.

 

[AndyMax]

Its written as a column.

Br Andy

 

[Matt Allington]

Ok. Is this your exact syntax? If so, the first 2 parameters are tables but they need to be columns

 

[AndyMax]

Ok, thx