How to Apply WHERE Clause in Power Query in EXCEL or Power BI Posted on April 8, 2021April 8, 2021 by Summa Lai Go to Query Editor, find the year column, then click drop down to select Number Filters: The corresponding Power Query will be generated via above action: