Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to 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] )
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.
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
13 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |