DAX new Calculated table

[Tota13]

Hi 

i want to create a new calculated table that get me the follwoing results: 

Flights handled	Main
1,2,3,4,7	A
3,4	B
1,2,6	C
6,7,8,9,10	D
4,5,9	E
8,9,10	F

and i have two tables one called flights and has these 4 columns: Flight number, fromtopair, from, to and the other table called Airports have two columns Main, sub. i want the new calculated column to get the flight numbers that the main airport or it's sub has handled. when the main airport or it's sub airport are one of the From or To column then we add the flight number to the main airport and the result should be like the table above. how can i do that in dax ? 

[v-zhangti]

Hi, @Tota13 

Can you provide some of the example data from the 2 tables and give examples of how to get the results you expect?

Best Regards

[Fowmy]

@Tota13 

It will be helpful if you could create a Power BI file with dummy data that represent your actual scenario and share it here. You may save the file in Google Drive and share the link here and grant permission to access the file. Explain the expected output as well.

[Tota13]

i need to make a new table such as the table above excuse me by mistake i wrote calculated column.