# Dax Test

## Quiz by Support - BusinessPromoted .com

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

20 questions
• Q1
What is the purpose of the EARLIER function in DAX?
To create time intelligence functions
To filter a table for earlier periods
To perform calculations on earlier dates
To refer to the value of an earlier row context
120s
• Q2
How can you create a calculated column that shows the cumulative total of sales by month?
CALCULATE(SUM(Sales[SalesAmount]), FILTER(ALL(Sales), Sales[Date] <= EARLIER(Sales[Date])))
SUMX(Sales, Sales[SalesAmount])
CALCULATE(SUM(Sales[SalesAmount]), DATESYTD(Sales[Date]))
TOTALYTD(SUM(Sales[SalesAmount]), Sales[Date])
120s
• Q3
What function would you use to calculate the rank of a product based on sales within a category?
RANKX(ALL(Sales), Sales[SalesAmount], , DESC, DENSE)
RANK(Sales[SalesAmount])
RANKX(Sales, Sales[SalesAmount], , DESC, DENSE)
RANK.EQ(Sales[SalesAmount])
120s
• Q4
How can you handle many-to-many relationships in DAX?
Use the BLANK function to remove duplicates
Use the USERELATIONSHIP function to create temporary relationships
Use the RELATEDTABLE function to combine tables
Use the CROSSFILTER function to manage the relationship
120s
• Q5
What is the difference between ALL and ALLSELECTED functions?
ALL ignores any filters on the table, while ALLSELECTED respects user selections
ALLSELECTED ignores all filters applied by the user
ALL respects user selections, while ALLSELECTED removes all filters
ALLSELECTED removes row context filters
120s
• Q6
How do you create a measure that calculates the sales growth from the previous year?
(SUM(Sales[SalesAmount]) - SUM(Sales[SalesAmount])) / SUM(Sales[SalesAmount])
CALCULATE(SUM(Sales[SalesAmount]), DATESYTD(Sales[Date]))
(SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Sales[Date])))/CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Sales[Date]))
SUMX(Sales, Sales[SalesAmount]) - SUM(Sales[SalesAmount])
120s
• Q7
What function would you use to return the last non-blank value in a column?
LASTBLANK
LASTVALUE
LASTDATE
LASTNONBLANK
120s
• Q8
How can you calculate the total sales for the last 3 months dynamically?
TOTALMTD(SUM(Sales[SalesAmount]), Sales[Date])
CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Sales[Date]))
CALCULATE(SUM(Sales[SalesAmount]), DATESINPERIOD(Sales[Date], LASTDATE(Sales[Date]), -3, MONTH))
DATESBETWEEN(Sales[Date], -3, TODAY())
120s
• Q9
Which function helps to retrieve the value from a related table?
RELATEDTABLE
RELATED
LOOKUPVALUE
EARLIER
120s
• Q10
How can you handle missing values in DAX calculations?
Use the ISBLANK function
Use the BLANK function
Use the IFERROR function
Use the COALESCE function
120s
• Q11
What is the role of the CALCULATETABLE function?
To create calculated columns in tables
To create table relationships
To perform aggregations on tables
To return a table modified by the filters
120s
• Q12
How can you apply a filter to a table only during a calculation without modifying the report filter?
Use the ALL function to remove existing filters
Use the FILTER function within CALCULATE
Apply the filter directly to the report
Use the USERELATIONSHIP function
120s
• Q13
How can you find the earliest date in a column?
FIRSTDATE
MIN
STARTDATE
EARLIER
120s
• Q14
What is the purpose of the CONTAINS function in DAX?
To concatenate strings
To create a logical condition
To filter a table based on a condition
To check if a table contains a specific value
120s
• Q15
How can you count distinct values in a column?
DISTINCTCOUNT
DISTINCT
COUNT
COUNTA
120s

Teachers give this quiz to your class