Forum Discussion
Power Query yields different row count when filtering where value <> 0
What i would do is to click on the Drop down and then select Advanced. And then put in your options there?
Also ensure that the column data type is set to Number (either decimal, fixed decimal or whole number) to ensure that it recognizes the zero.
Also when you refresh your data is it coming from a live source (database)? Because if there are constant updates it could be consistently changing.
Hi guavaq,
Thakgs for the response. I implemented your recommendation for the Advanced filter, ensuring the type is set to decimal in a prior step. I did this for all queries in the workbook. Unfortunately, I am seeing the same thing. RE: the DB question, the DB is static.
I went through a process of creating a copy of the query, removing steps and writing to a table. I then ran the query multiple times to see if I would get a different number of row counts. If the same row count was achieved each run, then I deleted the query, made a new copy, and added in one more step from the original query, then re-ran multiple times. The point of all of that was to isolate where in the query the different row counts was occurring. It isn't happening until the last step, which happens to be the filter for non zeros.
Any other ideas? Almost seems like it is some sort of issue/bug with PQ. When I used the Advanced filter, is there any way within the code to see if the filter was set using the Advanced filter option? I didn't see anything different.
Thanks,