I'm very new to Power Pivot and could use some help.
I have 2 different files with parts and dates that will be used for forecasting. We are trying to combine the 2 data sets into Power Query so that it will create a table that has the part number on the column, the month on the row, and the data in the middle.
Normally, I would just create a pivot table but I'm trying to create something that can just be a paste the data, and it will do the calculation for them.
Where I'm getting stuck is in dataset 1 data has the dates are individual days and in the column, and the total for each part number. Dataset 2 has months in a row and how I need the data to look.
Should I be using Power Query, Power Pivot, or something else?
In the dataset there will be other parts added to the dataset.
What is the best way to combine that data so that it looks like the dataset 2?
If anyone can give me a tutorial on how to make the data in Dataset1 look like Dataset2 what would be a great help.
I have 2 different files with parts and dates that will be used for forecasting. We are trying to combine the 2 data sets into Power Query so that it will create a table that has the part number on the column, the month on the row, and the data in the middle.
Normally, I would just create a pivot table but I'm trying to create something that can just be a paste the data, and it will do the calculation for them.
Where I'm getting stuck is in dataset 1 data has the dates are individual days and in the column, and the total for each part number. Dataset 2 has months in a row and how I need the data to look.
Should I be using Power Query, Power Pivot, or something else?
In the dataset there will be other parts added to the dataset.
What is the best way to combine that data so that it looks like the dataset 2?
If anyone can give me a tutorial on how to make the data in Dataset1 look like Dataset2 what would be a great help.