Help connecting two tables in Power bi

[tanvipal]

Hi, I have an airline delay data where i want to join two tables: flights and airports.  They have no common keys. 

The 'airports' table consists of the columns: Airport_IATA_CODE AIRPORT CITY STATE COUNTRY LATITUDE LONGITUDE.

The 'flights' table consists of the colums: YEAR MONTH DAY DAY_OF_WEEK AIRLINE FLIGHT_NUMBER TAIL_NUMBER ORIGIN_AIRPORT DESTINATION_AIRPORT SCHEDULED_DEPARTURE DEPARTURE_TIME DEPARTURE_DELAY TAXI_OUT WHEELS_OFF SCHEDULED_TIME ELAPSED_TIME AIR_TIME DISTANCE WHEELS_ON TAXI_IN SCHEDULED_ARRIVAL ARRIVAL_TIME ARRIVAL_DELAY DIVERTED CANCELLED CANCELLATION_REASON.

There are two more tables: The airlines table consists of the columns: IATA_CODE, AIRLINE. I dont have any common columns in flights table and airports table. How can i create a relationship between them? 

(Airport IATA code (3 characters) is different than the Airline IATA code(2 chars)

[flath]

Hi!
I can see your flight table have two columns ORIGIN_AIRPORT and DESTINATION_AIRPORT.
If the data from these two columns isn't under IATA AIRPORT codes, you could create a thir table that will consist of at least the following fields:
AIRPORT (name)

IATA_AIRPORT

Once you have this new dimension table with data that can be found on both tables (flights and airports), you can create the relationship between both tables.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! 😊