Hello All,
I have a giant table that i power queried together. And now i want to build individual tables off of it.
Question: Is it possible to do a two way look up to generate the first column? I can build everything else off that first column. Problem is i dont know how long that first column will be and the power query table is a living table that will be refreshed weekly so the individual tables should grow or retract base on what comes out of that table. I hope i made it as clear as i can.
EX:
Individual Table That meets this Criteria. Region: North & Schedule Shipping Date is in the Year 2020
Respectfully,
Ian
I have a giant table that i power queried together. And now i want to build individual tables off of it.
Question: Is it possible to do a two way look up to generate the first column? I can build everything else off that first column. Problem is i dont know how long that first column will be and the power query table is a living table that will be refreshed weekly so the individual tables should grow or retract base on what comes out of that table. I hope i made it as clear as i can.
EX:
ID | Name | order | # of Boxes Shipped | Process | Region | Shipping Date |
A-001 | Bob | 10000001 | 10 | ABC | North | 1/1/2021 |
A-002 | Bill | 10000002 | 5 | ABC | North | 6/30/2020 |
A-003 | Chris | 10000003 | 15 | DEF | Central | 4/5/2023 |
A-004 | Curt | 10000004 | 20 | JKL | North | 7/3/2020 |
A-005 | Dan | 10000005 | 10 | GHI | South | 9/20/2020 |
A-006 | David | 10000006 | 15 | XYZ | West Coast | 8/26/2022 |
A-007 | Frank | 10000007 | 5 | ABC | South Coast | 3/15/2020 |
Individual Table That meets this Criteria. Region: North & Schedule Shipping Date is in the Year 2020
ID | Name | # of Boxes Shipped | Scheduled Date of Shipping |
A-002 | Bill | 5 | 6/30/2020 |
A-004 | Curt | 20 | 7/3/2020 |
Respectfully,
Ian