Previous

Next

Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

What is a risk of having null values in a numeric column?

That function SUM of data is incorrect.

That function MAX of data will be incorrect.

That function AVERAGE of data will be incorrect.

2.

If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?

Append

Merge

Combine Column

3.

Which of the following selections aren't best practices for naming conventions in Power BI?

Rename columns to have spaces in them.

Abbreviate column names.

Replace values that have integers with human readable results.

You must answer all questions before checking your work.

Continue