DAX Quiz – 1 Copy – Learn Vertocity

DAX in PowerBI stands for

Data Analysis Expressions
Data Performance Index
Data Analysis and Exchange

DAX is a

Procedural language
Functional language
Machine languages
Assembly language

It is not necessary for a function to be present in a measure

True
False

A fully qualified column is

Its column name comes after the function involved
It's name is proceeded with table name
Its name precedes the table name
Its name is preceded with table name and the function

For the DAX Expression “Total Quantity =SUM(Transaction[Quantity])” if the table name changes to (Transaction Table ) the resultant exoression would be

Total Quantity =SUM(‘Transaction table’ [Quantity])
Total Quantity =SUM(“Transaction table” [Quantity])
Total Quantity =SUM(Transaction table [Quantity])
Total Quantity =SUM(Transaction table ” [Quantity]”)

Which of the following is not a DAX Operator

Arthimetic
Logical
Comparison
Assignment

Measures are visible in

Data view
Report view
Model view

How many distinct groups of quick measures are available in power bi?

5
6
4
3

Which of the following is a time intelligence quick measure

Quarter-over-quarter change
Quarter-over-month change
Month to month total
Quarter to day total

Quick measure can be created without using DAX expression but a DAX expression will always be associated with it once its created

True
False

To hide the columns in the visualization, that are not useful we need to

Delete those columns from the table in the query editor
Right click on the columns and click exclude the project
Delete those columns in the visualization tab
In the model tab select all the columns to hide and turn set is hidden property to on

“&” operator will

Concatenate 2 strings
Applies logical AND between 2 values
Applies logical OR between 2 values
None of the above

Measures are used when

Aggregation of columns are required
Aggregation of rows are required
Aggregation of columns and rows are required
Cross filtering is required

Is it possible to use FILTER() inside a measure?

Yes
No

When a table argument is passed ALL() will return

All the unique rows from the table
All the rows including duplicate values
All the unique columns from the table
The rows on which the filter is applied

DAX Quiz – 1 Copy

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

Leave a Comment Cancel reply