Forum Discussion
Building trends from multiple files
hello. thanks in advance for helping me. everyone here is always very helpful and quick to respond. I think this is going to be an easy one. I dump a daily report to a folder for pBI to trend. The ...
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