3-Minute Win: Use Power Query's 'Keep Rows Where' Filter Without Writing a Line of M
The Keep Rows filter in the Power Query UI handles 80% of row filtering tasks without you ever opening the Advanced Editor. Most people skip past it and go straight to writing M. Five clicks and you're done, and the M it generates is clean enough to modify later.