PL-300 Model the data Practice Question
Which TWO of the following are valid DAX functions for time intelligence?
⚠ Common exam trap
Microsoft often tests the distinction between general DAX functions (like CALCULATE and SUM) and dedicated time intelligence functions, trapping candidates who assume any function that works with dates qualifies as time intelligence.
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
✓
TOTALYTD
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.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
TOTALYTD
Why this is correct
TOTALYTD is a DAX time intelligence function that evaluates an expression over the year-to-date period based on a given date column. It returns a scalar value representing the cumulative total from the start of the year to the latest date in the current filter context. This function is specifically designed for time-based calculations, making it a valid answer.
- ✗
RANKX
Why it's wrong here
RANKX is a DAX function that computes the rank of an expression across a table, sorted in ascending or descending order. It is a ranking function, not a time intelligence function, because it does not manipulate or interpret date periods. It operates purely on the values of an expression for each row, independent of any calendar context.
- ✗
SUM
Why it's wrong here
SUM is a basic aggregation function that adds up all values in a single column, ignoring any relationship to time or dates. It is not a time intelligence function because it does not account for time periods like year-to-date or fiscal calendars. SUM simply returns the arithmetic total of numeric values within the current filter context, with no intrinsic time awareness.
- ✗
CALCULATE
Why it's wrong here
CALCULATE is a powerful context modifier that evaluates an expression under a modified filter condition, such as removing or adding filters. It is not a time intelligence function; it is instead a general-purpose function that can be combined with time intelligence formulas to create dynamic calculations. CALCULATE itself does not perform any period-specific analysis, making it an incorrect answer here.
- ✓
SAMEPERIODLASTYEAR
Why this is correct
SAMEPERIODLASTYEAR is a DAX time intelligence function that shifts a set of dates back by one year, returning a table of dates from the previous year. It is commonly used in comparisons like year-over-year sales growth, and it requires a continuous date column as an argument. This is a valid time intelligence function, hence it is a correct answer.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 217 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
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.