Report Builder overview in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample sales data for three products used in Report Builder to create a simple report.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	200

Formula Trace

SUM(B2:B4)

Step 1: SUM(100, 150, 200)

Cell Reference Map

    A       B
1 |Product| Sales |
2 |Apples | 100  |
3 |Bananas| 150  |
4 |Cherries| 200 |

Formula references cells B2, B3, and B4 for sales values.

Cells B2 to B4 contain sales numbers that the formula sums.

Result

    A       B
1 |Product| Sales |
2 |Apples | 100  |
3 |Bananas| 150  |
4 |Cherries| 200 |
5 |Total  | 450  |

The total sales of 450 is shown in cell B5, summing all sales values.

Sheet Trace Quiz - 3 Questions

What does the formula SUM(B2:B4) calculate?

A The total sales of all products

B The average sales of all products

C The sales of Apples only

D The number of products

Key Result

SUM(range) adds all numeric values in the specified cell range.