derive new column

[jacquelineq]

Hi! I'm trying to create a new column to derive the invoice no (in blue below) based on the ID match. I've used LOOKUPVALUE formula to no avail. Can anyone help me with this? Thanks!

ID	Invoice No	Extracted ID	New column
BOD856			INV7012
BOD269			INV9173
POL530	INV7012	BOD856
POL107	INV9173	BOD269

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a calculated column.

Expected new column CC =
LOOKUPVALUE ( Data[Invoice No], Data[Extracted ID], Data[ID] )

[jacquelineq]

Thanks! I did that and get an error - 'A table of multiple values was supplied where a single value was expected'. I've added a fourth parameter "" and it works now.