I use Power Query to transform data from Excel files into appends. There are two results that are loaded into the data model and a relationship is created between them. The data model is then loaded to a Power Pivot table.
It works well enough but on the Description field on the pivot table, there are blanks that must be filtered out by unchecking them.
The AppOrders are units to be produce for May 9, 2022, in this instance.
The SpOrders2022 has customer orders.
In my mind, the pivot table should only pull in the SpOrders2022 items that match in AppOrders but there are blanks. It may be that the blanks are orphans in the SpOrders2022 with no match in AppOrders table and filter is the easiest way to not show them????
I have attached a workbook and hope it helps.
I manage a production greenhouse and use this to know and tell production crew what orders to target when a planting list is generated.
Thank you for reading and look forward to your thoughts.
Lee
It works well enough but on the Description field on the pivot table, there are blanks that must be filtered out by unchecking them.
The AppOrders are units to be produce for May 9, 2022, in this instance.
The SpOrders2022 has customer orders.
In my mind, the pivot table should only pull in the SpOrders2022 items that match in AppOrders but there are blanks. It may be that the blanks are orphans in the SpOrders2022 with no match in AppOrders table and filter is the easiest way to not show them????
I have attached a workbook and hope it helps.
I manage a production greenhouse and use this to know and tell production crew what orders to target when a planting list is generated.
Thank you for reading and look forward to your thoughts.
Lee