Forum Discussion

Tota13's avatar
Tota13
Regular Visitor
2 years ago

DAX new Calculated table

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 ? 

calculated table

3 Replies

  • Tota13's avatar
    Tota13
    Regular Visitor
    2 years ago

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

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    2 years ago

    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