0
0
Power BIbi_tool~10 mins

Naming conventions in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This data shows different ways to name a measure or column representing total sales amount in Power BI.

CellValue
A1SalesAmount
A2TotalSales
A3total_sales
A4Total Sales
A5totalSales
B11000
B21000
B31000
B41000
B51000
Formula Trace
TotalSales = SUM(Sales[SalesAmount])
Step 1: SUM(Sales[SalesAmount])
Step 2: TotalSales = 1000
Cell Reference Map
   A           B
1  SalesAmount  1000
2  TotalSales   1000
3  total_sales  1000
4  Total Sales  1000
5  totalSales   1000
The SalesAmount column is the source data. Different naming styles for the measure TotalSales are shown in column A with their values in column B.
Result
   A           B
1  TotalSales   1000
The final measure named TotalSales shows the sum of SalesAmount as 1000, following a clear and consistent naming convention.
Sheet Trace Quiz - 3 Questions
Test your understanding
Which naming style is recommended for measures in Power BI?
ATotal Sales
Btotal_sales
CTotalSales
DtotalSales
Key Result
MeasureName = SUM(TableName[ColumnName]) sums values in a column and assigns to a measure.