This page has 0 threads | Add post

Exercises

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

Software ==>	Power BI (160 exercises)
Topic ==>	Calculated columns (12 exercises)
Level ==>	Relatively easy
Subject ==>	Power BI training

Use calculated columns to show a film's length in text format

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 .

Create a new Power BI report, and load data from the Films.csv file in the above folder:

The only two columns you'll need to do this exercise are the film title and its length in minutes, so you could if you like use Query Editor to remove all of the other columns (this is optional).

Create a calculated column to show the number of minutes for each film using this formula:

Left over minutes = MOD([RunTimeMinutes],60)

This divides the film length by 60 and gives the remaining minutes (so Jurassic Park above should show 6, since it lasts 2 hours and 6 minutes). Bear with ...

Add another calculated column to give the number of hours (this should equal the film length minus the left over minutes, divided by 60) using this formula:

Hours = ([RunTimeMinutes] - [Left over minutes])/60

You should now have something like this: