Forum Discussion
Incorrect Sums using folder to get data
Good Morning,
I feel like I am on a roll for asking questions. It seems this one budget document is giving me all sorts of issues. So basically I have an issue where the sum of all expenses is very incorrect. If I upload the files individually rather than through the folder it displays the correct sum. I am attaching a bunch of photos that describe the situation.
I can provide more screenshots if you need clarification. The first photo is just a sample if i uploaded things individually. The next set of photos is my actual working project that uses a folder to pull files
15 Replies
- AnonymousNot applicable
Anonymous,
When you load individual files, Power Query automatically performs data conversion. In you case when iterating all files in a folder, make sure you change each column's data type after combining all the files. Try this out first and if the issue still persists, let me know.
- AnonymousNot applicable
Anonymous
Do you mean within the sample file? Or after everything? Because I didnt really edit the sample file.
-Michael
- AnonymousNot applicable
Anonymous,
After each query