Font size
WorksheetsPower BI 04 - DAX
Total questions: 8
Worksheet time: 4mins
Which two types of fields can DAX be used to create?
Calculated Column & Calculated Fields
Calculated Column & Measures
Calculated Fields & Measures
Measures & Calculated Items
What's the difference between calculated columns and measures?
Calculated Columns understand row context
Measures understand filter context
Calculated column values are stored in tables
Which of the following formulas would make the most sense as a calculated column?
=SUM(Sales[quantity])
=AVERAGE(Products[RetailsPrice])
=DISTINCOUNT(Customer[CustomerName])
=Products[RetailsPrices] * 0.75
When would it be most appropriate to use the && operator?
To concatenate two text strings
To create an AND condition between two expressions
To concatenate more than two text strings
To create an AND condition between more than two expressions
Which of the following would the COUNTA function count?
Non-black cells (Numerical or non-numerical)
Numerical values only
Distinct values only
Text values only
Which formula could you use to replace one word or character in a text string with another?
SWITCH
SEARCH
SUBSTITUTE
FIND
Which of the following returns a table, rather than a single scalar value?
COUNTA
FILTER
RELATED
All of the above
What is the purpose of the following function:
=CALCULATE([Profit],Territories[Country]="USA")
Calculate a measure named "Profit" across the entire Territories table
Sums the "Profit" column for rows where Country = "USA"
Creates a new column named "Profit" which is calculated for all rows where country = "USA"
Evaluates the "Profits" measure for rows where Country = "USA" in the Territories table
