WorksheetsData Analysis Expressions
Total questions: 10
Worksheet time: 2mins
It is a library of functions and operators that can be combined to build formulas and expressions used by Microsoft BI Tools.
Data Analysis Expressions
Azure Analysis Services
Power BI
Pivot for Excel
The following are the types of calculations that can be added in a data model using DAX, EXCEPT:
Calculated Columns
Measures
Calculated Tables
Calculated Graphs
It is best to use calculated columns when dealing with huge amount of data.
True
False
Which of the following functions should be used if you want to convert a value to text?
CONCATENATE
SWITCH
FORMAT
EXACT
Which of the following functions should be used if you want to evaluate an expression against a list of values and returns one of multiple possible result expressions?
SWITCH
CONCATENATE
IF
RELATED
This function returns the sum of an expression evaluated for each row in a table.
SUM
SUMX
AVERAGE
AVERAGEX
This function returns the count of interval boundaries crossed between two dates.
EOMONTH
DATESBETWEEN
DATEDIFF
DATESINPERIOD
This function returns a related value from another table.
RELATED
RELATEDTABLE
CONCATENATE
SWITCH
Which of the following functions should you used if you want to know the total number of unique customers who bought from your store?
COUNT
DISTINCTCOUNT
MAXX
SUMX
This function returns a table that contains a column of dates that begins with a specified start date and continues until a specified end date.
DATES IN PERIOD
DATESBETWEEN
ENDOFMONTH
TOTALYTD
