Quizalize logo
placeholder image to represent content

Dax Test

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
20 questions
Show answers
  • 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