Power BI DAX code to add a column to a table from a lookup / LOV table.
This example adds the "Airline Carrier's Name" to the Air Tickets table using the Airline Carriers IATA ID.
Airline = LOOKUPVALUE('Airline Carrier'[Airline],'Airline Carrier'[CarrierCode],'Air Ticket'[CarrierCode])
Source: https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
