How to create query using data from existing tables in Power Query Editor

Hi Cherry,

Yes, the table above is my desired output. Below is the query I created. First, all the five tables were appended into one query using the Frcast data as the starting point. Then I grouped all transactions to produce the values as well as create a conditional column to create the different transactions. 

The issue that I encountered by using the Frcast table as the starting point is that if a part number is not in the frcast query then I will not receive any data. I need the format to look like the table above and if there is no value than zero should populate for any of the transactions.  This is when I realized that I need to tie my data using a date table so that data can be shown based on a 12 month view regardless of the value.  Below is the list of the consolidated query with the appended five tables.  Please let me know if you have any questions about the inforrmation. Thank you too for your help.