Forum Discussion
Incorrect Sums using folder to get data
Anonymous,
Where do these hidden rows come frome?
Anonymous
Basically It's an expense report that gets reported monthly into a folder. The way they are reported "monthly" Is by updating the YTD expense report and hiding the rows for the previous months if that makes any sense. It appears that when these files are pulled into Power BI what I think is happening, is the rows that are hidden are shown and an incorrect sum results because I have a lot of repeat transactions when I shouldn't
-Michael
Does the file name have any sort of context, like Month Name or Month Number? If so, you could use that to filter out all the other data that does not fit in that month.
That's just a high level guess though, is it possible to get two sample files? Or just some random actual data but correct on the file is named? Just thinking out loud here....