Solved: derive new column

jacquelineq · ‎06-15-2022

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 · ‎06-15-2022

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

View solution in original post

Jihwan_Kim · ‎06-15-2022

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

jacquelineq · ‎06-16-2022

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.

derive new column

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024