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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
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

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

Hadn't thought I'd need to hit the refresh again if I shifted the order but that does make sense.  Thank you.