We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hey y'all,
I am trying to create a virtual table that will be a subset of a datatable (3PointPlans). This table contains the locations along paths of various flights. Each path(cfmuflightkey) inlcudes locations, each with a pointname, a latitude and longitude, and a sequence number. A sample of the datatable is given here.
cfmuflightkey | pointname | lat | lon | sequenceNumber |
54937201 | NILDU | 42.2603 | 3.82861 | 59 |
54937201 | TEBLA | 41.3812 | 2.3251 | 76 |
54937201 | TUPOX | 43.9758 | 5.40306 | 52 |
54937203 | KORIS | 35.8333 | -6.23917 | 26 |
54937203 | MAR | 37.0553 | -4.9399 | 34 |
54937203 | VAGNO | 35.74 | -6.3 | 25 |
54937204 | ABRON | 42.6142 | 8.14778 | 29 |
54937204 | LEMG | 36.6871 | -4.51247 | 74 |
54937204 | TOSGA | 37.6257 | -2.30736 | 43 |
54937205 | FAFEQ | 40.1694 | -3.4607 | 65 |
54937205 | OLGUD | 50.7322 | -1.52278 | 26 |
54937205 | VADOX | 43.7667 | -3.93278 | 37 |
What I want to do is to maintain the same columns, but to filter it to where it inlcudes all the pointnames, locations, sequence numbers of paths that go through a given point name.
In other words, not just filter the pointname column for the given pointname, but the other points that any path that would go through it would include.
Here is an example of what I'm looking to achieve for the given pointname LUXUR
cfmuflightkey | pointname | lat | lon | sequenceNumber |
54943084 | ARMED | 42.5 | -14 | 2 |
54943084 | BARDI | 40.5835 | -6.30246 | 4 |
54943084 | LUXUR | 38.2133 | 3.42194 | 3 |
54943084 | PAGRE | 37.71 | 5 | 5 |
54943129 | ARMED | 42.5 | -14 | 1 |
54943129 | BARDI | 40.5835 | -6.30246 | 2 |
54943129 | LUXUR | 38.2133 | 3.42194 | 3 |
54943129 | PAGRE | 37.71 | 5 | 4 |
54943139 | ARMED | 42.5 | -14 | 94 |
54943139 | BARDI | 40.5835 | -6.30246 | 95 |
54943139 | LUXUR | 38.2133 | 3.42194 | 96 |
54943139 | PAGRE | 37.71 | 5 | 97 |
I can get the list of the distinct CFMUflightkey values that I want, but how to then virtually re-construct the table filtered as I want it is proving to be a blocking point. I think I need to use either SUMMARIZE, SUMMARIZECOLUMS, or something along those lines, but I just don't know how to construct it. I have a variable for the shortened list of CFMUflightkeys, which is
Solved! Go to Solution.
Is it something like this?
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
I think that will work for me, thanks.
Is it something like this?
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
User | Count |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
71 | |
57 | |
51 | |
45 |