Forum Discussion
SIH007_1
3 years agoFrequent Visitor
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...
- 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.
- 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 😞
jennratten
3 years agoSuper User
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_13 years agoFrequent Visitor
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 😞