1. Where can a calculated column be used?

Excel calculation. PivotTable Field List. PivotTable Calculated Item. PivotTable Calculated Field.

2. What happens when you use an aggregation function (i.e., SUM) in a calculated column? It calculates a value based on the values in the row. You receive an error. It calculates a value based upon the entire column. It turns the calculated column into a measure.

3. What is one of the Rules of a Measure? Redefine the measure, don't reuse it. Never use a measure within another measure. Only use calculated columns in a measure. Reuse the measure, don't redefine it.

4. What type of measure is created within the Power Pivot data model? Implicit. Exact. Explicit. Calculated Field.

5.What is the advantage of creating a SUM measure in the Data Model versus placing the field in the Values quadrant of the PivotTable? The SUM measure is "portable" and can be used in other measure calculations. It is more accurate than the calculation in the PivotTable. Once you connect a PivotTable to a data model, you can no longer add fields to the Values quadrant. It is the only way to add fields to the Values quadrant of a Power PivotTable.

6. What are the Aggregation functions used for in DAX? Take data from a column or table and aggregate the data based upon function Add dimensions to a data model. Add a formula to a PivotTable. Allows you to use the GETPIVOTDATA function in Excel.

7. Which DAX function counts the number of different cells in a column COUNT. COUNTA. DISTINCTCOUNT. COUNTROWS.

8. Which DAX function counts the number of non-empty cells in a column? COUNT. DISTINCTCOUNT. COUNTROWS. COUNTA.

9. When should you use a Calculated Column instead of an Iterator function? When you want to create a measure. When you want to add the calculation to the Filter, Rows, or Columns quadrant of a PivotTable. When you want to limit the size of your data set. When you can bring the data in from your data source.

10. When should you use an Iterator function instead of a Calculated Column? When you want to create a new dimension in your data. When you want to add the calculation to the Filter, Rows, or Columns quadrant of a PivotTable. When you want your data model to be more efficient because no values are stored in the table. When you can bring the data in from your data source.