Session 3 Quiz
DAX and Power BI Mastery Quiz
Test your knowledge on DAX and Power BI with this engaging quiz! Whether you're a beginner or an experienced user, this quiz will help you evaluate your understanding of key concepts and best practices.
Key Features:
- 8 carefully crafted questions
- Multiple-choice format
- Instant feedback on your answers
1. What will the following DAX do: CALCULATE( SUM(principal_outstanding),LASTDATE(to_date))
Calculate sum of POS on the max 'to_date' in list
Calculate sum of POS till the last 'to_date' in list
Calculate sum of POS irrespective of 'to_date'
None of the above
2. Power Query only brings a preview data and only apply transformations after you close and apply
True
False
3. The Language used by DAX is ________________.
M
Python
Java
SQL
4. Which of the following are PowerBI best practises
Keep the measures in same tables
Keep measures in a different table
Create a separate calendar table
Use date from one central table only for slicer
5. Calculate a result from an expression formula and the result can only be viewed in the visualization______________
Filter
Function
Calculated Column
Measures
6. A function that can only work on numeric fields is_______________
ISNUMBER
AVERAGE
CONCATENATE
AND
7. What DAX function can be used to return a value in a column if a condition is met?
IF
VLOOKUP
SUMIF
COUNT
{"name":"Session 3 Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge on DAX and Power BI with this engaging quiz! Whether you're a beginner or an experienced user, this quiz will help you evaluate your understanding of key concepts and best practices.Key Features:8 carefully crafted questionsMultiple-choice formatInstant feedback on your answers","img":"https:/images/course8.png"}
More Surveys
Data Intelligence Team Weekly Fair
9413
Chart visualization 101
12622
Excel Training
5229
Postgresql DBA Test
1588
Let's know more about you
4265
Safety Analyst Training
17834
Background of Attendees
8419
Understanding the Stock Market Quiz
17838
Shared tools
6320
Purchasing Document Menu Search Filter
3225
Know about IoT
10521
CS FOLDER PROJECT
1589