Make your own Quiz

Session 3 Quiz

Name:

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

0

{"name":"Session 3 Quiz", "url":"https://www.quiz-maker.com/Q3VJ2F5K7","txt":"Name:, 1. What will the following DAX do: CALCULATE( SUM(principal_outstanding),LASTDATE(to_date)), 2. Power Query only brings a preview data and only apply transformations after you close and apply","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

Powered by

Powered by: Quiz Maker