Combine three datasets in Power Query

Dear Excel experts,

I need to combine three different datasets which I already cleaned. They are all in the same Excel file and I need/want to combine them with Power Query:

- Partnumber information, with the columns: partnumber, part description, the delivery time in days and the delivery time in months (If {Delivery time in days}<30;1;{Delivery time in days}/30)

- Orders for the past 250 days, with the columns: partnumber, customer number, Year-Month of order (YYYY-MM) and the sum of all parts that are send within that month.

- Forecast information about the last x years, with the columns: partnumber, date for when the forecast counts (so when the real order is needed) (in Year-Month (YYYY-MM)), the quantity that is needed that month, the date the forecast is delivered at us (in Year-Month (YYYY-MM)) and the forecast code.


The goal is to check the sum of quantity in the orders with the forecast of the lead time ago. The lead time is the number of days in which we can deliver. So I want to check the forecast they handed in the lead time ago, for today (for example).

The goal is to create a pivot table, in which you can Cleary see the difference (or not). I just do not know how to combine the three power query's, so I will match the part numbers, but also to use put the forecast with the delivery time in the past next to the current forecast.

Who can help me solve this Power Query case?

Thank you VERY much in advance

Hi CK76,

Thank you for your quick response.
I use the data to compare (sometimes daily and other times weekly, so we need to be able to refresh the data quick) the forecast with actual dispatched orders. We want to be able to check if our customers order more than they forecasted. If that is the case, they should pay the costs we need to make in order to fulfill their orders. This is a tool that should help with checking.

I am sorry, but I do not understand what you mean with fact tables and how I should implement that in my file.

Thank you in advance