Quizalize logo
placeholder image to represent content

Dax Test 4

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

Teachers give this quiz to your class