Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

derive new column

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 Invoi...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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] )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.