DAX Date Functions Quiz

Date is an important part of business analytics. When working with large data sets and multiple tables, it makes sense to create a Dates table and use time intelligence functions. These DAX date functions can give you insights using various date and time dimensions.

Get to know more about time intelligence functions by participating in this online quiz. 

Read the following questions carefully and find the correct answer from the options provided. There’s no time limit to answer each question so take all the time you need, and then select the one you believe is correct. Some questions are more difficult and will naturally take longer to answer.

Remember: don’t cheat yourself!

CALENDARAUTO automatically finds the minimum and maximum year of all the date columns and calculated columns included across the whole data model, and generates all the dates included between these years.
Which function could use to get dates for the year to date, in the current context?
What is the correct definition of the DATEADD function?
To calculate year-to-date value of Sales for each month, you can use following functions. Which is wrong?
Which DAX function returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context?
Which DAX function returns a table that contains a column of dates that begins with a start date and continues for the number of specified intervals?
Which DAX function returns the current date in datetime format and always returns a time of 12:00:00 AM?
Which function would you use to return the day of week between 1 and 7?
Which DAX function returns a table that contains a column of dates that begins with a start date and continues until the end date?
Which function returns the month as a number between 1 and 12?
DAX Date Functions Quiz
You got {{userScore}} out of {{maxScore}} correct
{{title}}
{{image}}
{{content}}

Return to DAX Quizzes