topic DAX new Calculated table in DAX Commands and Tips

DAX new Calculated table

Tota13 — Sat, 25 Nov 2023 21:31:47 GMT

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 ?

Re: DAX new Calculated table

Tota13 — Sat, 25 Nov 2023 21:33:18 GMT

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

Re: DAX new Calculated table

Fowmy — Sun, 26 Nov 2023 06:49:15 GMT

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.

Re: DAX new Calculated table

v-zhangti — Tue, 28 Nov 2023 02:10:55 GMT

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