0
0
Power BIbi_tool~10 mins

Data source and dataset in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows product names and their sales numbers. It represents a dataset loaded from a data source into Power BI.

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

Formula references column B (Sales) in rows 2 to 4.
The formula uses the 'Sales' column from the dataset, which corresponds to cells B2 to B4 in this table.
Result
   A        B        C
1 Product  Sales    Total Sales
2 Apples   100      450
3 Bananas  150
4 Cherries 200

The measure 'Total Sales' shows the sum of all sales: 450.
The final result is a measure showing the total sales value 450, calculated by summing all sales in the dataset.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the expression 'SUM('SalesData'[Sales])' calculate?
AThe total of all sales values in the dataset
BThe average sales value
CThe maximum sales value
DThe number of products
Key Result
SUM(column) adds all values in the specified column of the dataset.