Naming conventions in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a measure with a proper name.

Power BI

Total Sales = SUM([1][SalesAmount])

Drag options to blanks, or click blank then click option'

A1Sales

Bsales

CSales

DTotal-Sales

Attempts:

3 left

💡 Hint

Common Mistakes

Starting names with numbers

Using special characters like '-'

Using lowercase when uppercase is standard for table names

The measure name should start with a letter and avoid special characters. 'Sales' is a valid table name.

2fill in blank

medium

Complete the code to follow naming conventions for calculated columns.

Power BI

Profit Margin = DIVIDE([1][Profit], [1][SalesAmount])

Drag options to blanks, or click blank then click option'

Asales

BSales-Data

C1Sales

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase table names

Starting table names with numbers

Including special characters in names

Table names should be capitalized and not start with numbers or contain special characters. 'Sales' is correct.

3fill in blank

hard

Fix the error in the measure name to follow naming conventions.

Power BI

[1] = SUM(Sales[Units])

Drag options to blanks, or click blank then click option'

ASales_Units

BUnits

CSales

DSalesData

Attempts:

3 left

💡 Hint

Common Mistakes

Using hyphens in measure names

Starting names with numbers

Using spaces in names

Measure names should not contain hyphens. Using underscore '_' is acceptable and improves readability.

4fill in blank

hard

Fill both blanks to create a properly named calculated table and column.

Power BI

NewTable = SELECTCOLUMNS([1], "[2]", [SalesAmount])

Drag options to blanks, or click blank then click option'

ASales

Bsales

CTotalSales

DTotal-Sales

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase table names

Using hyphens in column names

Using spaces in names

Table names start with uppercase letters without special characters. Column names should be descriptive and use camel case without spaces or special characters.

5fill in blank

hard

Fill all three blanks to define a measure with proper naming conventions and syntax.

Power BI

[1] = CALCULATE(SUM([2][Revenue]), FILTER([2], [2][Region] = "West"))

Drag options to blanks, or click blank then click option'

ATotalRevenue

BSales

CSalesData

Dtotal_revenue

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase measure names

Using inconsistent table names

Using underscores in measure names

Measure names should be descriptive and use camel case starting with uppercase. Table names should be capitalized without special characters. Using the same table name consistently is important.