Previous

Next

Check your knowledge

Completed

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

1.

Which statement about calculated tables is true?

Calculated tables increase the size of the semantic model.

Calculated tables are evaluated by using row context.

Calculated tables are created in Power Query.

Calculated tables cannot include calculated columns.

2.

Which statement about calculated columns is true?

Calculated columns are created in the Power Query Editor window.

Calculated column formulas are evaluated by using row context.

Calculated column formulas can only reference columns from within their table.

Calculated columns can't be related to non-calculated columns.

3.

You're developing a Power BI desktop model that sources data from an Excel workbook. The workbook has an employee table that stores one row for each employee. Each row has a reference to the employee's manager, which is also a row in the employee table. You need to add several columns to the Employee table in your model to analyze payroll data within the organization hierarchy (like, executive level, manager level, and so on). Which technique will you use to add the columns?

Add persisted columns to a table by using T-SQL.

Add column expressions in a view by using T-SQL.

Add computed columns by using M.

Add calculated columns by using DAX.

You must answer all questions before checking your work.

Continue