0
0
Power BIbi_tool~10 mins

First Power BI report - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows product names and their sales amounts.

CellValue
A1Product
B1Sales
A2Apples
B2100
A3Bananas
B3150
A4Cherries
B4200
Formula Trace
Total Sales = SUM(Sales[Sales])
Step 1: SUM(Sales[Sales])
Step 2: 100 + 150 + 200
Step 3: Total Sales = 450
Cell Reference Map
   A        B
1 Product  Sales
2 Apples   100
3 Bananas  150
4 Cherries 200

Formula references Sales column cells B2, B3, B4
The formula uses the Sales column values from cells B2 to B4 to calculate total sales.
Result
   A           B
1 Product   Sales
2 Apples    100
3 Bananas   150
4 Cherries  200

Total Sales: 450
The report shows product sales and a card visual displaying Total Sales as 450.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM(Sales[Sales]) do?
ACounts the number of products
BAdds all sales values in the Sales column
CFinds the highest sales value
DSubtracts sales values
Key Result
SUM(column) adds all numeric values in the specified column.