Session 3 Quiz

Create an illustration of a person analyzing data on a computer screen, surrounded by vibrant graphs and charts, symbolizing DAX and Power BI analysis.

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

8 Questions2 MinutesCreated by CalculatingData101

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

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?

VLOOKUP

SUMIF

COUNT

Session 3 Quiz

DAX and Power BI Mastery Quiz

More Quizzes