Dax Test
Quiz by Support - BusinessPromoted .com
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
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
20 questions
Show answers
- Q1What is the purpose of the EARLIER function in DAX?To create time intelligence functionsTo filter a table for earlier periodsTo perform calculations on earlier datesTo refer to the value of an earlier row context120s
- Q2How 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
- Q3What 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
- Q4How can you handle many-to-many relationships in DAX?Use the BLANK function to remove duplicatesUse the USERELATIONSHIP function to create temporary relationshipsUse the RELATEDTABLE function to combine tablesUse the CROSSFILTER function to manage the relationship120s
- Q5What is the difference between ALL and ALLSELECTED functions?ALL ignores any filters on the table, while ALLSELECTED respects user selectionsALLSELECTED ignores all filters applied by the userALL respects user selections, while ALLSELECTED removes all filtersALLSELECTED removes row context filters120s
- Q6How 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
- Q7What function would you use to return the last non-blank value in a column?LASTBLANKLASTVALUELASTDATELASTNONBLANK120s
- Q8How 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
- Q9Which function helps to retrieve the value from a related table?RELATEDTABLERELATEDLOOKUPVALUEEARLIER120s
- Q10How can you handle missing values in DAX calculations?Use the ISBLANK functionUse the BLANK functionUse the IFERROR functionUse the COALESCE function120s
- Q11What is the role of the CALCULATETABLE function?To create calculated columns in tablesTo create table relationshipsTo perform aggregations on tablesTo return a table modified by the filters120s
- Q12How can you apply a filter to a table only during a calculation without modifying the report filter?Use the ALL function to remove existing filtersUse the FILTER function within CALCULATEApply the filter directly to the reportUse the USERELATIONSHIP function120s
- Q13How can you find the earliest date in a column?FIRSTDATEMINSTARTDATEEARLIER120s
- Q14What is the purpose of the CONTAINS function in DAX?To concatenate stringsTo create a logical conditionTo filter a table based on a conditionTo check if a table contains a specific value120s
- Q15How can you count distinct values in a column?DISTINCTCOUNTDISTINCTCOUNTCOUNTA120s