Query folding in Power Query in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows products with their IDs, names, categories, and prices.

Cell	Value
A1	ProductID
B1	ProductName
C1	Category
D1	Price
A2	101
B2	Chair
C2	Furniture
D2	50
A3	102
B3	Desk
C3	Furniture
D3	150
A4	103
B4	Pen
C4	Stationery
D4	5
A5	104
B5	Notebook
C5	Stationery
D5	10

Formula Trace

Table.SelectRows(Source, each [Category] = "Furniture" and [Price] > 40)

Step 1: Source

Step 2: each [Category] = "Furniture"

Step 3: each [Price] > 40

Step 4: each [Category] = "Furniture" and [Price] > 40

Step 5: Table.SelectRows(Source, condition)

Cell Reference Map

     A          B           C           D
1 | ProductID | ProductName | Category  | Price
2 |    101   |   Chair    | Furniture |  50  
3 |    102   |   Desk     | Furniture |  150 
4 |    103   |   Pen      | Stationery|  5   
5 |    104   | Notebook   | Stationery|  10  

Formula references columns C (Category) and D (Price) for filtering.

The formula uses the Category column (C) and Price column (D) to filter rows.

Result

     A          B           C           D
1 | ProductID | ProductName | Category  | Price
2 |    101   |   Chair    | Furniture |  50  
3 |    102   |   Desk     | Furniture |  150 

Only rows with Category 'Furniture' and Price > 40 remain after filtering.

The filtered table shows only furniture products priced above 40.

Sheet Trace Quiz - 3 Questions

Which rows does the filter condition keep?

A Rows where Category is 'Furniture' and Price > 40

B Rows where Category is 'Stationery' and Price > 40

C Rows where Price < 40

D All rows

Key Result

Table.SelectRows filters rows by applying a condition to each row.