Which DAX Functions are Valid for Time Intelligence?
Which TWO of the following are valid DAX functions for time intelligence? (Select two.)
Quick Answer
The answer is TOTALYTD and DATEADD. TOTALYTD is a valid DAX time intelligence function that computes the year-to-date running total of a measure, while DATEADD shifts dates forward or backward by a specified number of intervals such as days, months, or years. Both belong to DAX’s dedicated set of time intelligence functions, which require a properly marked date table with continuous dates to work correctly. On the Microsoft Power BI Data Analyst PL-300 exam, this question tests your ability to distinguish genuine time intelligence functions from general date functions like TODAY or CALENDAR, which are not part of this set. A common trap is confusing DATEADD with EDATE or DATEDIFF, which are not time intelligence functions. For a quick memory tip, remember that valid time intelligence functions always return a table of dates or a scalar value based on a date range, not just a single date or calculation.
⚠ Common exam trap
Microsoft often tests the distinction between iterator functions (like RANKX, MINX, CONCATENATEX) and dedicated time intelligence functions (like DATEADD, TOTALYTD), causing candidates to confuse functions that perform row-by-row operations with those that manipulate date ranges.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
DATEADD
DATEADD is a valid DAX time intelligence function that shifts dates forward or backward by a specified number of intervals (days, months, quarters, years). TOTALYTD is also a valid time intelligence function that calculates the year-to-date value of an expression. Both are part of the dedicated time intelligence function set in DAX, which requires a properly marked date table with continuous dates.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
RANKX
Why it's wrong here
RANKX is a ranking function.
- ✓
DATEADD
Why this is correct
DATEADD shifts dates by an interval.
- ✗
CONCATENATEX
Why it's wrong here
CONCATENATEX concatenates strings.
- ✗
MINX
Why it's wrong here
MINX is an iterator function.
- ✓
TOTALYTD
Why this is correct
TOTALYTD calculates year-to-date.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on PL-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which TWO of the following are valid DAX functions for time intelligence?
easy- ✓ A.TOTALYTD
- B.RANKX
- C.SUM
- D.CALCULATE
- ✓ E.SAMEPERIODLASTYEAR
Why A: TOTALYTD is a valid DAX time intelligence function that calculates the year-to-date value of an expression, typically used with a date column to aggregate data from the start of the year to the current context. It requires a properly marked date table with continuous dates to function correctly.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.