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 Quizzes
Data and Analytics_Introductory course
1059
Power Bi Visualization Quiz
9417
Big Data Analytics Quiz 1
10511
Analytics 1.0
6319
Power BI
327
Data Literacy Post Test 17 March 2023
10511
Big Data 1
94260
Tableau Training
10512
Singlestore quiz-booth 42
5262
Analytics: deep dive session
6317
Big Data Analytics
10528
AWS Data Quiz
1059