Skip to content

Search for:

GK Quiz
Sports Quiz
Space Quiz
Festivals Quiz

Python Quiz
GK Quiz
Space Quiz
Sports Quiz

Search for:

Test Your Knowledge

Power BI Quiz
0

Quiz on Date and Time Functions in Power BI DAX

by Quiz Orbit Team

Date and time functions in DAX are essential for working with temporal data in Power BI. Functions like TODAY, NOW, YEAR, MONTH, and DAY help in building time-based reports, performing date calculations, and enabling dynamic analysis for dashboards.

Time limit: 0

Quiz Summary

0 of 15 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 15 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Current
Review / Skip
Answered
Correct
Incorrect

Question 1 of 15
1. Question
What does the TODAY() function return in DAX?
- Current date and time
- Current date only
- Current time only
- First day of the month
Correct
Incorrect
Question 2 of 15
2. Question
Which function gives both the current date and time in DAX?
- DATE
- NOW
- CURRENT
- DATETIME
Correct
Incorrect
Question 3 of 15
3. Question
What will YEAR(TODAY()) return?
- The month of the current date
- The current year
- The current day number
- The current date in text format
Correct
Incorrect
Question 4 of 15
4. Question
Which function extracts the month number from a date?
- MONTH
- DATE
- DAY
- FORMAT
Correct
Incorrect
Question 5 of 15
5. Question
What will DAY(DATE(2025, 8, 11)) return?
- 11
- 8
- 2025
- Monday
Correct
Incorrect
Question 6 of 15
6. Question
Which function creates a date from year, month, and day numbers?
- DATEVALUE
- DATE
- MAKEDATE
- CONVERTDATE
Correct
Incorrect
Question 7 of 15
7. Question
What does DATEVALUE(“2025-08-11”) return?
- A text string
- A date value
- An integer only
- Error
Correct
Incorrect
Question 8 of 15
8. Question
How do you extract the hour from the current time?
- HOUR(NOW())
- GETHOUR(TODAY())
- TIMEPART(NOW())
- TIMEHOUR()
Correct
Incorrect
Question 9 of 15
9. Question
Which function will return the minute part of NOW()?
- MINUTE(NOW())
- MIN(NOW())
- GETMINUTE(NOW())
- TIME(NOW())
Correct
Incorrect
Question 10 of 15
10. Question
Which function gives the second component from a datetime value?
- SEC
- SECOND
- GETSECOND
- TIMESECOND
Correct
Incorrect
Question 11 of 15
11. Question
What will MONTH(DATE(2025,12,25)) return?
- 2025
- 12
- 25
- December
Correct
Incorrect
Question 12 of 15
12. Question
Which function returns the date N days from today?
- DATEADD(TODAY(), N)
- TODAY() + N
- ADDDAYS(TODAY(), N)
- DATEINCREASE()
Correct
Incorrect
Question 13 of 15
13. Question
What will YEAR(NOW()) return?
- The current date
- The current year
- The time portion
- The month number
Correct
Incorrect
Question 14 of 15
14. Question
Which function converts a date into a specific text format?
- FORMAT
- TEXT
- DATETOTEXT
- STRINGDATE
Correct
Incorrect
Question 15 of 15
15. Question
If TODAY() returns 2025-08-11, what will DAY(TODAY()) return?
- 8
- 11
- 2025
- Monday
Correct
Incorrect

Summary

These Power BI DAX Date and Time Functions MCQs cover extracting year, month, and day, generating the current date/time, and converting date formats. Mastering these functions is crucial for building time-intelligent Power BI reports and dashboards.

Tags: power bi quiz power bi quiz on date and time function quiz on date and time functions in power bi dax quiz on date function in power bi quiz on power bi quiz on time function in power bi

Quiz Orbit Team

At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Δ

Next story Quiz on Math & Trigonometric Functions in Power BI DAX
Previous story Quiz on SQL Aggregate Functions

About Us
Contact Us
Privacy Policy
Disclaimer

Quiz Orbit © 2026. All Rights Reserved.