topic derive new column in DAX Commands and Tips

derive new column

Anonymous — Thu, 16 Jun 2022 03:13:13 GMT

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

Re: derive new column

Jihwan_Kim — Thu, 16 Jun 2022 03:51:12 GMT

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] )

Re: derive new column

Anonymous — Thu, 16 Jun 2022 08:48:29 GMT

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.