Skip to content

Search for:

GK Quiz
Sports Quiz
Space Quiz
Festivals Quiz

Python Quiz
GK Quiz
Space Quiz
Sports Quiz

Search for:

Test Your Knowledge

Power BI Quiz
0

Quiz on DAX Syntax and Functions in Power BI

by Quiz Orbit Team

DAX Syntax and Functions form the foundation of writing calculations in Power BI. The syntax follows a structured format, with function names, parameters, and expressions. DAX includes various categories of functions such as aggregation, filter, date & time, logical, text, and statistical. Mastering syntax rules and function usage is essential for accurate and optimised data modelling.

Time limit: 0

Quiz Summary

0 of 15 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 15 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Current
Review / Skip
Answered
Correct
Incorrect

Question 1 of 15
1. Question
What character is used to start a DAX formula?
- @
- =
- #
- :
Correct
Incorrect
Question 2 of 15
2. Question
Which of the following is the correct syntax for the SUM function?
- SUM(Table.Column)
- SUM(Column)
- SUM([ColumnName])
- SUM(ColumnName)
Correct
Incorrect
Question 3 of 15
3. Question
In DAX, which operator is used for string concatenation?
- &
- +
- CONCAT
- ||
Correct
Incorrect
Question 4 of 15
4. Question
Which of the following is NOT a valid DAX function category?
- Aggregation
- Logical
- Machine Learning
- Date & Time
Correct
Incorrect
Question 5 of 15
5. Question
What is the purpose of the RELATED() function?
- To combine text strings
- To retrieve a value from a related table
- To remove filters from a column
- To calculate row counts
Correct
Incorrect
Question 6 of 15
6. Question
Which function returns the largest value in a column?
- MAX()
- MAXX()
- TOPN()
- MAXVALUE()
Correct
Incorrect
Question 7 of 15
7. Question
Which of these is an iterator function in DAX?
- SUMX()
- COUNTROWS()
- CALCULATE()
- VALUES()
Correct
Incorrect
Question 8 of 15
8. Question
What is the correct syntax for the IF function in DAX?
- IF(condition, result_if_true, result_if_false)
- IF(condition, result_if_false, result_if_true)
- IF(condition, result_if_true)
- IF(condition)
Correct
Incorrect
Question 9 of 15
9. Question
Which function returns a table instead of a single value?
- VALUES()
- SUM()
- MAX()
- MIN()
Correct
Incorrect
Question 10 of 15
10. Question
Which of the following operators is used for logical AND in DAX?
- &
- AND
- &&
- +
Correct
Incorrect
Question 11 of 15
11. Question
What is the main difference between COUNT() and COUNTA()?
- COUNT() counts numeric values, COUNTA() counts all non-blank values
- COUNT() is faster than COUNTA()
- COUNT() works on text, COUNTA() works on numbers
- Both are identical
Correct
Incorrect
Question 12 of 15
12. Question
Which DAX function is used to create running totals?
- SUMMARIZE()
- CALCULATE() + FILTER()
- RANKX()
- TOTALYTD()
Correct
Incorrect
Question 13 of 15
13. Question
Which syntax is correct for referencing a table in DAX?
- {TableName}
- "TableName"
- 'TableName'
- [TableName]
Correct
Incorrect
Question 14 of 15
14. Question
Which function removes filters from a column or table?
- REMOVE()
- ALL()
- CLEARFILTERS()
- DELETE()
Correct
Incorrect
Question 15 of 15
15. Question
Which of the following is TRUE about DAX syntax?
- Column names must be enclosed in square brackets
- Table names must be enclosed in double quotes
- DAX is case-sensitive
- Functions must end with a semicolon
Correct
Incorrect

Summary

These DAX Syntax and Functions MCQs cover key rules for writing valid DAX expressions, understanding function categories, using operators, and applying functions like SUM(), RELATED(), IF(), and VALUES(). A strong grasp of DAX syntax is essential for building accurate and efficient Power BI reports.

Tags: dax syntax and functions in power bi quiz power bi quiz power bi quiz on dax syntax and functions in power bi quiz on dax functions in power bi quiz on dax syntax and functions in power bi quiz on dax syntax in power bi quiz on power bi

Quiz Orbit Team

At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Δ

Next story Quiz on SQL WITH clause
Previous story Quiz on SQL Common Table Expressions

About Us
Contact Us
Privacy Policy
Disclaimer

Quiz Orbit © 2026. All Rights Reserved.