0
0
Power BIbi_tool~10 mins

CSV and text file import in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sample sales data imported from a CSV file with columns Date, Product, and Sales.

CellValue
A1Date
B1Product
C1Sales
A22024-01-01
B2Apples
C2100
A32024-01-02
B3Bananas
C3150
A42024-01-03
B4Cherries
C4200
Formula Trace
SUM('ImportedData'[Sales])
Step 1: 'ImportedData'[Sales]
Step 2: SUM([100, 150, 200])
Cell Reference Map
   A         B          C
1 Date      Product    Sales
2 2024-01-01 Apples     100
3 2024-01-02 Bananas    150
4 2024-01-03 Cherries   200

[Sales column values used in formula are in cells C2, C3, C4]
The formula references the Sales column (cells C2 to C4) from the imported CSV data.
Result
   A         B          C          D
1 Date      Product    Sales      Total Sales
2 2024-01-01 Apples     100        450
3 2024-01-02 Bananas    150
4 2024-01-03 Cherries   200
The Total Sales measure shows the sum of all sales from the imported CSV data, which is 450.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula SUM('ImportedData'[Sales]) calculate?
AThe number of sales records
BThe average sales value
CThe total of all sales values in the imported data
DThe maximum sales value
Key Result
SUM(column) adds all numeric values in the specified column from imported data.