Forum Discussion
Building trends from multiple files
In Power Query use the folder connector. Ingest all the files (make sure to keep the file name around). Then in Power BI create your report as needed.
Thanks for your reply. I am looking for a much more advanced answer though. I am using the folder option for quite a number of tables to build trending... but Im looking for specific coding examples of how to pull column data from multiple different files in a folder to show a table of data, historically. A dynamic column for "today", "yesterday", "last week", and "last month" using the rolling files for those dynamic days.
Provide sample data, and I can show you sample Power Query code.
i did, they are embedded in my original post
Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523