Help with this quiz on Use Advanced Calculations With Dax Formulas please!
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.
11. What is the symbol for the “OR” logical operand?
|| – double pipe symbol.
^^ – double caret symbol.
!! – double explanation symbol.
&& – double ampersand symbol.
12.What is the symbol for the “AND” logical operand?
|| – double pipe symbol.
^^ – double caret symbol.
!! – double explanation symbol.
&& – double ampersand symbol.
13. When creating a measure that includes one of the Filter functions, what should you consider?
The speed of the required calculation.
The context of the measure so that you apply the formula correctly.
The number of records in your data set.
The audience using your data set.
14. What is one possible use of the HASONEVALUE function?
Provide a test to determine if the PivotTable is filtered to one distinct value.
Use it to ignore any filters applied to a PivotTable.
Use it to ignore all but one filter applied to a PivotTable.
Use it to determine if a column has only one value.
15. What is the syntax of the FILTER function?
FILTER(< table>,< filter>)
FILTER (< table>)
FILTER(< filter>,< table>).
FILTER(< filter>).
16. Which of the following is a requirement of a Date Table?
All columns must be sorted by the date column.
Must include columns for calendar year dates.
Completely consecutive dates, NO gaps.
Must not include columns for fiscal years.
17. How does the data model determine which table is the date table?
It automatically knows based upon the data in the date table.
You relate the date table to your other tables.
The first column of the date table has the date values.
You go to the Design tab and select the option “Mark as Date Table.”
18. What is the purpose of Time Intelligence functions in DAX?
Create measures that manipulate data context to create dynamic calculations.
Create measures that compare calculations over date periods.
Create measures that check the result of an expression and create conditional results.
Create measures that aggregate values based upon the function context.
19. What is the first step of the DAX Calculation Process?
Check the filters of any CALCULATE function.
Evaluate the arithmetic.
Detect pivot coordinates.
Manually calculate the desired measure.
20. In the DAX Calculation Process, what is the purpose of “applying the filters to the tables in the Power Pivot data tables?”
It will recalculate the measure in the Measure Area.
It will apply these filters to the PivotTable.
It will apply these filters to all related tables.
It will recalculate the measure in the PivotTable.
