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

Create DAX calculated columns in Microsoft Power BI Desktop to generate new values for a list of tallest buildings.

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 - Calculated Columns.pbix file in the folder shown above and switch to the Table view of the Building table.

A table of tallest buildings in Microsoft Power BI Desktop

You can see the data in the model by switching to the Table view.

From the ribbon choose Table tools | New column to create a new calculated column.

Creating a calculated column in Microsoft Power BI Desktop

The formula bar will be activated, ready for you to type your formula.

Change the name of the column to Total floors.

Naming a calculated column in Microsoft Power BI Desktop

Edit the text on the left of the = sign to give your column a name.

Write a formula to add together the values of the Floors above ground and Floors below ground columns and press Enter to complete the calculation.

The column of answers appears at the right hand side of the table.

Create a new calculated column called Average floor height which divides the Height m column by the Floors above ground column. You could do this using the division operator:

Column Name = Value to Divide / Value to Divide By

Or using the DIVIDE function:

Column Name = DIVIDE( Value to Divide, Value to Divide By )

Whichever technique you choose, you should end up with a new column of messy-looking numbers.