0
0
Power BIbi_tool~10 mins

Basic arithmetic in DAX in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales and Cost values for three products.

CellValue
A1Sales
A2100
A3200
A4300
B1Cost
B240
B380
B4120
Formula Trace
Total Profit = SUM(Sales[Sales]) - SUM(Sales[Cost])
Step 1: SUM(Sales[Sales])
Step 2: SUM(Sales[Cost])
Step 3: 600 - 240
Cell Reference Map
    A       B
1 |Sales | Cost |
2 | 100  |  40  |
3 | 200  |  80  |
4 | 300  | 120  |
The formula uses the Sales and Cost columns from rows 2 to 4.
Result
    A       B       C
1 |Sales | Cost | Profit |
2 | 100  |  40  |        |
3 | 200  |  80  |        |
4 | 300  | 120  |        |
5 |       |       |  360   |
The Total Profit calculated as 360 is shown in cell C5.
Sheet Trace Quiz - 3 Questions
Test your understanding
What is the sum of the Sales column?
A240
B600
C360
D100
Key Result
SUM(Column1) - SUM(Column2) calculates the difference between two totals.