Forum Discussion
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 | Invoice No | Extracted ID | New column |
| BOD856 | INV7012 | ||
| BOD269 | INV9173 | ||
| POL530 | INV7012 | BOD856 | |
| POL107 | INV9173 | BOD269 |
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] )
2 Replies
- Jihwan_Kim
Super User
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] )