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 returns a ranking position for each row within a table, iterating a specified expression; it performs no date-based filtering or period shifting. It is tempting because it is a common iterator used in measures, but it belongs to statistical ranking, not time intelligence, where functions such as TOTALYTD or SAMEPERIODLASTYEAR operate on a marked date table.
- ✓
DATEADD
Why this is correct
DATEADD shifts a date column by a specified interval, returning dates offset by days, months, quarters or years. It is a genuine time-intelligence function, satisfying the stem because it operates on dates rather than aggregating values like SUM or COUNT.
- ✗
CONCATENATEX
Why it's wrong here
CONCATENATEX joins the text results of an expression across rows into a single delimited string; it performs no calendar-based aggregation or period comparison. It is tempting because it is a frequently used iterator, but it belongs to text concatenation, not time intelligence, which requires functions such as DATESYTD or DATEADD evaluated against a marked date table.
- ✗
MINX
Why it's wrong here
MINX returns the smallest value across a column or expression; it performs no date-based filtering or period shifting. It is tempting because it aggregates values, but time intelligence requires calendar-aware functions such as TOTALYTD, SAMEPERIODLASTYEAR or DATEADD.
- ✓
TOTALYTD
Why this is correct
TOTALYTD evaluates an expression over the year-to-date period ending at the latest date in the current filter context. It is a genuine time-intelligence function, satisfying the stem because it performs calendar-based cumulative aggregation rather than row-level arithmetic.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 524-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.