RELATED for cross-table values in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the DAX formula to get the related product name from the Products table.

Power BI

ProductName = RELATED([1][ProductName])

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

ACustomers

BSales

CProducts

DOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Using the current table name instead of the related table.

Confusing RELATED with LOOKUPVALUE.

The RELATED function fetches a value from a related table. Here, Products is the related table containing the ProductName column.

2fill in blank

medium

Complete the DAX formula to get the related customer city from the Customers table.

Power BI

CustomerCity = RELATED([1][City])

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

ACustomers

BProducts

CSales

DOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting a table that does not contain the City column.

Using the current table name instead of the related table.

The RELATED function retrieves the City from the Customers table, which is related to the current table.

3fill in blank

hard

Fix the error in the DAX formula to correctly get the related category name.

Power BI

CategoryName = RELATED([1][CategoryName])

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

ACategory

BCategories

CProducts

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular instead of plural table names.

Using unrelated table names.

The correct related table is Categories. Using 'Category' or other names causes errors because the table name must match exactly.

4fill in blank

hard

Fill both blanks to create a measure that sums sales amount using RELATED to get the product price.

Power BI

TotalSales = SUMX(Sales, Sales[Quantity] * RELATED([1][[2]]))

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

AProducts

BPrice

CCost

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong table or column names.

Confusing Cost with Price.

The measure multiplies Quantity by the related Price from the Products table to calculate total sales.

5fill in blank

hard

Fill all three blanks to create a calculated column that shows the customer country from the related Customers table and the order year.

Power BI

CustomerCountryYear = RELATED([1][[2]]) & " - " & YEAR([3][OrderDate])

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

ACustomers

BCountry

COrders

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong table for OrderDate.

Mixing up column names.

This formula gets the Country from the related Customers table and combines it with the year extracted from the OrderDate in the Orders table.