Lessons
Business Intelligence MCQs
Power BI DAX MCQS
DAX CALCULATE Function MCQS DAX RANKX And Drill Through MCQS DAX Functions List MCQS

DAX Functions List MCQS

Q. Which of these is a text function in DAX?

A
UPPER()
B
MAX()
C
SWITCH()
D
DISTINCTCOUNT()
Solution:

UPPER() manipulates text strings, placing it in the text function category.

Q. Where is the most reliable up-to-date source for the complete list of DAX functions?

A
A static downloaded PDF
B
Microsoft's official online DAX function reference
C
A random forum post
D
The Power BI splash screen
Solution:

Microsoft’s online reference updates with each release, unlike a static PDF that can go stale.

Q. Which function is used to safely divide two numbers in DAX, avoiding a divide-by-zero error?

A
SUM()
B
DIVIDE()
C
AVERAGE()
D
COUNT()
Solution:

DIVIDE() is the mathematical function designed to handle division safely, including a built-in fallback for zero denominators.

Related Questions

Q. DAX Variables MCQS

View Solution

Q. DAX CALCULATE Function MCQS

View Solution

Q. DAX Text Functions MCQS

View Solution
Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.