Forum Discussion

SIH007_1's avatar
SIH007_1
Frequent Visitor
3 years ago
Solved

Strange error with calculation

Hi,   I have a problem with Power Query, I absolutely don't understand: We get data from SAP which we store in a folder by month - below you see the import text for the single files - only query n...
  • jennratten's avatar
    3 years ago

    Hello - I recommend you take a closer look through the individual query results.  If they really are correct individually then the appended/summed result would be correct also.

  • SIH007_1's avatar
    SIH007_1
    3 years ago

    Hi, thank you for your reply - problem was the Excel files generated from SAP - in 2 files the filter was set to the wrong year - that caused the problem 😞