Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
545 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Software ==> | DAX (59 exercises) |
Topic ==> | Calculated columns (11 exercises) |
Level ==> | Relatively easy |
Subject ==> | Power BI training |
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.
Open the Tallest buildings - Conditional Functions.pbix file in the folder shown above and switch to the Table view of the Building table.
Add a calculated column called Has basement which tests if the value of the Floors below ground column equals 0. If so, the formula should return No, otherwise it should return Yes. You can see the syntax of the IF function below:
Column Name = IF( Logical test, Answer if true, Answer if false )
Create a matrix visual which shows the number of buildings which do or do not have a basement:
Your matrix could resemble this one.
Add a calculated column called Century which uses an IF function to show the century in which the building was opened. A building which opened before the year 2001 belongs to the 20th Century (our list doesn't include any earlier buildings), otherwise it belongs to the 21st Century.
Use a matrix to display the values shown in the diagram below:
Buildings are getting bigger.
Create a calculated column called Size which uses the SWITCH function to assign each building to a category according to the following table:
Height m | Category |
---|---|
Less than 400 | Tiny |
400 to less than 500 | Small |
500 to less than 600 | Medium |
600 to less than 700 | Big |
700 or more | Massive |
Remember that you can set the first argument of the SWITCH function to TRUE() to allow you to write a sequence of logical tests and answers.
Use a chart visual to show the number of buildings and average of total floors for each size category.
Despite some wild exaggerations, Trump Tower isn't bigly enough to warrant its own category.
Create a calculated column called Location which tests if the Coordinates column is blank. If so, the formula should return Unknown location, otherwise it should return the value of the Coordinates column.
A sample of the results you should see.
Save and close the file.
You can find other training resources for the subject of this exercise here:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.