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
Hi CK_92
Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind (which columns to use, merge and why?) . You may post a link to Excel stored in the cloud. Please read this sticky post - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523