Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 

      Do you mean within the sample file? Or after everything? Because I didnt really edit the sample file.

       

      -Michael

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous,

        After each query