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,
We haven’t received a response with the requested sample data to help troubleshoot your issue effectively.
To proceed further, please share a minimal and clean sample dataset (not a screenshot) along with the expected output. This helps the community understand and resolve your question faster.
Thank you.
Hi CK_92,
Please share sample data relevant to this thread and let us know the expected outcome, as this will help us reproduce the scenario more easily.
Thank you.