Incremental refresh in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales data by date for a week. This data is used to demonstrate incremental refresh filtering by date.

Cell	Value
A1	Date
B1	Sales
A2	2023-01-01
B2	100
A3	2023-01-02
B3	150
A4	2023-01-03
B4	200
A5	2023-01-04
B5	130
A6	2023-01-05
B6	170

Formula Trace

FILTER('Sales', 'Sales'[Date] >= DATE(2023,1,3) && 'Sales'[Date] <= DATE(2023,1,5))

Step 1: DATE(2023,1,3)

Step 2: DATE(2023,1,5)

Step 3: 'Sales'[Date] >= DATE(2023,1,3)

Step 4: 'Sales'[Date] <= DATE(2023,1,5)

Step 5: ('Sales'[Date] >= DATE(2023,1,3)) && ('Sales'[Date] <= DATE(2023,1,5))

Step 6: FILTER rows where condition is TRUE

Cell Reference Map

    A          B
1 | Date     | Sales  |
2 |2023-01-01|  100   |
3 |2023-01-02|  150   |
4 |2023-01-03|  200   | <-- Included
5 |2023-01-04|  130   | <-- Included
6 |2023-01-05|  170   | <-- Included

The formula references the 'Date' column from the Sales table to filter rows between 2023-01-03 and 2023-01-05.

Result

    A          B
4 |2023-01-03|  200   |
5 |2023-01-04|  130   |
6 |2023-01-05|  170   |

The filtered table shows only sales data for dates from January 3 to January 5, which is the incremental refresh range.

Sheet Trace Quiz - 3 Questions

Which dates are included after applying the incremental refresh filter?

A 2023-01-03, 2023-01-04, 2023-01-05

B 2023-01-01, 2023-01-02

C 2023-01-01 to 2023-01-05 all dates

D Only 2023-01-05

Key Result

FILTER(table, table[column] >= start_date && table[column] <= end_date) filters rows by date range for incremental refresh.