This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	DAX (59 exercises)
Topic ==>	Calculated columns (11 exercises)
Level ==>	Relatively easy
Subject ==>	Power BI training

Use the RELATED function in DAX to create a calculated column for adding labels to a chart.

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open the Tallest Buildings - Related.pbix file in the folder shown above. The report contains a chart showing the height of each building.

A bar chart showing height of buildings in Power BI Desktop.

The axis labels show the Building name but we'd like to include the City and Country as well.

Add a calculated column called Name and location to the Building table. Use the & operator to concatenate a comma and a space to the end of each building's name. Don't forget to use double-quotes to enclose literal text.

A concatenated calculated column in DAX.

Each building name should have a comma and space after its name.

Edit the formula to concatenate the name of the City to the end of the string. You can use the RELATED function to access the value of a column in another table.