One table Vlookup equivalent in DAX
Dear community, I'm trying to get shipment C013720578 to be shown in column Group for all rows. Shipment C013720578 is the main shipment, out of 4 shipments linked to invoice 1891846520. I need to do this for all Invoices in column Invoice. My first try was lookupvalue Column = LOOKUPVALUE('BRIDGE FULL'[Shipment],'BRIDGE FULL'[Invoice & main],'BRIDGE FULL'[Invoice & Shipment Type]) This wouldn't work becuase there are duplicates (in the Search Value I think), and I got this error: A table of multiple values was supplied where a single value was expected. How do I modify the formula below please? or something completely different? (hint: shipment C012293295 currently shown in column Group is the very first shipment of the entire big table) Invoice Shipment Shipment Type Shipment Type - Main Invoice & main Invoice & Shipment Type Group 1891846520 C013720583 ZT13 not main 1891846520main 1891846520not main C012293295 1891846520 C013720577 ZT11 not main 1891846520main 1891846520not main C012293295 1891846520 C013720579 ZT13 not main 1891846520main 1891846520not main C012293295 1891846520 C013720578 ZT12 main 1891846520main 1891846520main C012293295 1891846523 C013720577 ZT11 not main 1891846523main 1891846523not main C012293295 1891846523 C013720579 ZT13 not main 1891846523main 1891846523not main C012293295 1891846523 C013720586 ZT13 not main 1891846523main 1891846523not main C012293295 1891846523 C013720578 ZT12 main 1891846523main 1891846523main C012293295 1891846524 C013720579 ZT13 not main 1891846524main 1891846524not main C012293295 1891846524 C013720586 ZT13 not main 1891846524main 1891846524not main C012293295 1891846524 C013720577 ZT11 not main 1891846524main 1891846524not main C012293295 1891846524 C013720578 ZT12 main 1891846524main 1891846524main C012293295
