0
0
Power BIbi_tool~10 mins

Mobile layout view in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sample sales data by region and month used to demonstrate mobile layout view in Power BI.

CellValue
A1Sales
B1Region
C1Month
A21000
B2North
C2Jan
A31500
B3South
C3Jan
A41200
B4North
C4Feb
A51300
B5South
C5Feb
Formula Trace
SUM(Sales)
Step 1: SUM({1000, 1500, 1200, 1300})
Cell Reference Map
    A       B       C
1 |Sales |Region |Month |
2 | 1000 | North | Jan  |
3 | 1500 | South | Jan  |
4 | 1200 | North | Feb  |
5 | 1300 | South | Feb  |
The formula references the Sales column (A2:A5) to calculate the total sales.
Result
    A       B       C       D
1 |Sales |Region |Month |Total |
2 | 1000 | North | Jan  |      |
3 | 1500 | South | Jan  |      |
4 | 1200 | North | Feb  |      |
5 | 1300 | South | Feb  | 5000 |
The total sales value 5000 is shown in cell D5 as the result of the SUM formula.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM(Sales) calculate?
AThe total of all sales values
BThe average sales value
CThe sales value for the North region only
DThe sales value for January only
Key Result
SUM(column) adds all numeric values in the specified column.