Forum Discussion

mvgust's avatar
mvgust
Icon for Helper III rankHelper III
3 years ago
Solved

Why would group by be filtering out records

I've got a table with 2.4 million records. I'm running into a situation where when using the group by function, it's incorrectly filtering out records.  I've got timecard records, and I'm looking ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi mvgust ,

     

    I'm not able to reproduce this issue during my own tests.

    I suspect that your preview cache may be getting confused by your process order i.e. Filter > Group > Move Filter.

    Try going to the Home tab in Power Query and hitting 'Refresh Preview'.

     

    Pete

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Not really a solution but I copied your data snapshot and m code and it works as expected, have you done a manual preview refresh when on the last step or output to a table and checked that entries to see if they appear?