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 ==>	Average difficulty
Subject ==>	Power BI training

Use DAX to add calculated columns to a Power BI data model.

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

Add a calculated column called Tour length to calculate the length of each tour in years. You can do this by subtracting the Start year from the End year and adding 1 to the result.

Create a table visual which shows a list of tours sorted so that the longest one appears at the top. Your table could resemble the one shown below:

A sorted table visual in Power BI Desktop.

The long goodbyes?

Add a chart visual which shows the sum of Tour length for each Artist, sorted with the longest touring artist at the top.

Fortunately, every member of the Rolling Stones has a free bus pass.

Add three more calculated columns according to the table shown below:

Column name	What it should do
Shows per year	Divide Shows by Tour length
Avg show revenue	Divide Actual gross by Shows
Avg attendance	Divide Attendance by Shows