Creating dataflows in Power BI - Formula Evaluation Walkthrough

Sample Data

Sample customer data table with IDs, names, and countries to be used in a Power BI dataflow.

Cell	Value
A1	CustomerID
B1	Name
C1	Country
A2	101
B2	Alice
C2	USA
A3	102
B3	Bob
C3	Canada
A4	103
B4	Charlie
C4	USA

Formula Trace

Table.SelectRows(Source, each [Country] = "USA")

Step 1: Source

Step 2: each [Country] = "USA"

Step 3: Table.SelectRows(Source, each [Country] = "USA")

Cell Reference Map

    A          B          C
1 CustomerID   Name      Country
2 101         Alice      USA  <-- included
3 102         Bob       Canada
4 103         Charlie    USA  <-- included

The formula references the 'Country' column in the source table to filter rows where Country is 'USA'. Rows 2 and 4 meet this condition.

Result

    A          B          C
1 CustomerID   Name      Country
2 101         Alice      USA
3 103         Charlie    USA

The resulting table after applying the filter shows only customers from the USA.

Sheet Trace Quiz - 3 Questions

What does the formula Table.SelectRows(Source, each [Country] = "USA") do?

A Adds a new column named USA

B Deletes rows where Country is USA

C Keeps only rows where Country is USA

D Sorts the table by Country

Key Result

Table.SelectRows filters a table by keeping rows that meet a condition.