Microsoft Power BI Cookbook

Query filter example steps

1. Create a new blank query and open the Advanced Editor window.
2. Use the Table.SelectRows() function to apply the US query predicate.
3. From a new blank query, filter on the Children column with a >= operator.

Figure 50: M expression for the United States Customers query

Figure 51: M expression for the Customers w3+ Children query

• Table.SelectRows() is the primary table-filtering function in the M language.
• It's functionally aligned with the FROM and WHERE clauses of SQL.
• Observe that variable names are used as inputs ...