SharePoint and OneDrive sources in Power BI - Cell-by-Cell Formula Trace

Sample Data

This data represents files stored in SharePoint or OneDrive with their sizes in MB and last modified dates.

Cell	Value
A1	FileName
B1	FileSizeMB
C1	ModifiedDate
A2	Report1.xlsx
B2	2.5
C2	2024-06-01
A3	Data.csv
B3	1.2
C3	2024-05-28
A4	Presentation.pptx
B4	4.0
C4	2024-06-03

Formula Trace

=SUM(B2:B4)

Step 1: B2

Step 2: B3

Step 3: B4

Step 4: SUM(2.5, 1.2, 4.0)

Cell Reference Map

    A          B          C
1 | FileName | FileSizeMB | ModifiedDate
2 | Report1.xlsx  |    2.5    | 2024-06-01
3 | Data.csv     |    1.2    | 2024-05-28
4 | Presentation.pptx |    4.0    | 2024-06-03

Formula references cells B2, B3, and B4 for file sizes.

The formula sums the file sizes from cells B2 to B4.

Result

    A          B          C
1 | FileName | FileSizeMB | ModifiedDate
2 | Report1.xlsx  |    2.5    | 2024-06-01
3 | Data.csv     |    1.2    | 2024-05-28
4 | Presentation.pptx |    4.0    | 2024-06-03
5 | Total    |    7.7    |

The total file size of all files is calculated as 7.7 MB and shown in cell B5.

Sheet Trace Quiz - 3 Questions

What is the value in cell B3 used in the formula?

A 4.0

B 2.5

C 1.2

D 7.7

Key Result

SUM(range) adds all numeric values in the specified cell range.