Forum Discussion
Right data structure for Inventory Forecast data
- Use “long format” data: Instead of adding new columns each month, add new rows with a ForecastMonth column.
Store all files in one folder: Use Power BI’s Folder connector to auto-merge them.
Automate with Power Query: Clean one sample file, and apply the same steps to all others.
Optional: Extract month from filename if needed.
No more manual edits—just drop the new file in the folder and refresh Power BI
- Use “long format” data: Instead of adding new columns each month, add new rows with a ForecastMonth column.
Store all files in one folder: Use Power BI’s Folder connector to auto-merge them.
Automate with Power Query: Clean one sample file, and apply the same steps to all others.
Optional: Extract month from filename if needed.
No more manual edits—just drop the new file in the folder and refresh Power BI