Business Intelligence with Microsoft Power BI - with Material - Rounding Off Functions

The video tutorial explains how to use rounding functions in Power Query within Power BI. It covers three main functions: round down, round up, and standard round. Each function is demonstrated with examples, showing how to achieve the lowest, highest, or specified decimal rounding. The tutorial also highlights how to modify rounding settings and emphasizes the simplicity of these operations in Power Query.

What is the first step in setting up a query for rounding numbers in Power Query?

• Click on the 'Add Column' tab

• Remove all columns except the one to be rounded

• Duplicate the existing query

• Select the column to be rounded

What does the 'Round Down' function do to the number 5.78?

• Rounds it to 6

• Rounds it to 5

• Keeps it as 5.78

• Rounds it to 5.8

How does the 'Round Up' function handle the number 219.5?

• Rounds it to 219.6

• Keeps it as 219.5

• Rounds it to 220

• Rounds it to 219

Which function allows you to specify the number of decimal places to round to?

• Round Down

• Round

• Round Up

• None of the above

What can you do if you want to change the rounding settings after applying them?

• Delete the entire query

• Start a new query

• Re-import the data set

• Use the settings button to modify