Compare Shipped And Received Items With Power Query And Power Pivot

 
Published on July 3, 2016
Channel: Doug H
Category: Education
Source: Youtube

This video shows how to use Power Query and Power Pivot to compare units ordered, shipped and received. It assumes a scenario where data for the ordered and shipped data come from one source and the received data comes from another. Therefore the tables would be separate and possibly have different header fields. This example uses the concept of a common table or join table with unique values to help create the filtering. P.S. Feel free to provide a comment or share it with a friend! ------------------------------------------------------------------------------------------------- Subscribe to the Blog: http://myexcelcharts.blogspot.com