18 DAX Functions questions from the Power BI bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.
Free to start: the 2-minute IT readiness check — six questions and a result.
A.the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
B.an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
C.a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression
D.a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
Answer + AI explanation with Pro
2. Which term means: "the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression"?
Mid
A.RELATED
B.FILTER
C.ALL
D.Context transition
Answer + AI explanation with Pro
3. Which statement is correct?
Mid
A.Context transition — a lookup that pulls a value from the one-side of a relationship into the current many-side row
B.Context transition — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
C.Context transition — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
D.Context transition — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
Answer + AI explanation with Pro
4. What is Time intelligence?
Mid
A.a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
B.the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
C.a lookup that pulls a value from the one-side of a relationship into the current many-side row
D.an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
Answer + AI explanation with Pro
5. Which term means: "the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table"?
Mid
A.Time intelligence
B.ALL
C.FILTER
D.VAR
Answer + AI explanation with Pro
6. Which statement is correct?
Mid
A.Time intelligence — a lookup that pulls a value from the one-side of a relationship into the current many-side row
B.Time intelligence — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
C.Time intelligence — a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression
D.Time intelligence — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
Answer + AI explanation with Pro
7. What is FILTER?
Mid
A.an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
B.the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
C.a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
D.a lookup that pulls a value from the one-side of a relationship into the current many-side row
Answer + AI explanation with Pro
8. Which term means: "an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation"?
Mid
A.FILTER
B.Context transition
C.VAR
D.ALL
Answer + AI explanation with Pro
9. Which statement is correct?
Mid
A.FILTER — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
B.FILTER — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
C.FILTER — a lookup that pulls a value from the one-side of a relationship into the current many-side row
D.FILTER — a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
Answer + AI explanation with Pro
10. What is ALL?
Senior
A.a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
B.the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
C.an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
D.the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
Answer + AI explanation with Pro
11. Which term means: "a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators"?
Senior
A.Time intelligence
B.ALL
C.FILTER
D.Context transition
Answer + AI explanation with Pro
12. Which statement is correct?
Senior
A.ALL — a lookup that pulls a value from the one-side of a relationship into the current many-side row
B.ALL — a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
C.ALL — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
D.ALL — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
Answer + AI explanation with Pro
13. What is RELATED?
Senior
A.the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
B.a lookup that pulls a value from the one-side of a relationship into the current many-side row
C.a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
D.the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
Answer + AI explanation with Pro
14. Which term means: "a lookup that pulls a value from the one-side of a relationship into the current many-side row"?
Senior
A.Time intelligence
B.VAR
C.FILTER
D.RELATED
Answer + AI explanation with Pro
15. Which statement is correct?
Senior
A.RELATED — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
B.RELATED — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
C.RELATED — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
D.RELATED — a lookup that pulls a value from the one-side of a relationship into the current many-side row
Answer + AI explanation with Pro
16. What is VAR?
Mid
A.the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
B.a lookup that pulls a value from the one-side of a relationship into the current many-side row
C.a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression
D.a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
Answer + AI explanation with Pro
17. Which term means: "a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression"?
Mid
A.Time intelligence
B.ALL
C.VAR
D.FILTER
Answer + AI explanation with Pro
18. Which statement is correct?
Mid
A.VAR — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
B.VAR — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
C.VAR — a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
D.VAR — a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression
Answer + AI explanation with Pro
Free to start
Start with a free readiness check
Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every DAX Functions question come with Pro.