And, from Tables there are many more transformations applied. There are actually less with the Folder option.
I haven’t experienced a problem like this when getting data from an Excel file which is a table that is updated with new data regularly. However when ...
Hi Mynda, Yes they are all the same structure just with different data I’m the columns. When I added my second csv file it is not updating and ...
Hi Catalin - I can’t get your file to download that you suggest to try.
CSV files all have the same headers and as I add a new files each day they will also have the same headers. I was looking to try this method after a...
When I add my second CSV file to my folder and refresh, my pivot table isn’t updating automatically with the new information.
I corrected this in power query by duplicating the date column, then extracted the year and replacing this New column as my Year column so that my sli...
Thanks so much!
Hi Mynda, Thank you for your prompt responses and all of your feedback! I appreciate it. My data sources are from external files that I pu...