DAX Scenarios Quiz

Scenario analysis is an important aspect of business intelligence because it anticipates and provides valuable insights to a broad range of possible future outcomes.

This type of analysis examines the amount of risk in a variety of potential events, ranging from highly probable to highly improbable.

Test your knowledge of DAX scenarios when you participate in this online quiz.

Read the following questions carefully and find the correct answer from the options provided. There’s no time limit to answer each question so take all the time you need, and then select the one you believe is correct. Some questions are more difficult and will naturally take longer to answer.

Remember: don’t cheat yourself!

We have two tables 'Product' and 'Sales' with a relationship between them 1 : to many. We want to create a calculated column in the product table for the division between sales price ('Sales'[SalesPrice]) and product price ('Product'[ProductPrice]). Which function is correct to use?
We have two tables 'Product' and 'Sales' with a relationship between them 1 : to many. We want to create a calculated column in the sales table for the division between sales price ('Sales'[SalesPrice]) and product price ('Product'[ProductPrice]). Which function is correct to use?
Consider the syntax of CALCULATE:

[Measure] : = CALCULATE ( Expression, Condition1, …, Condition).

The mandatory parameters are both Expression and Condition1
The following pattern 'CALCULATE( [Total Sales] ,SAMEPERIODLASTYEAR( Dates[Date] ))' would give….
In the example Total Sales = Sum('Fact'[Cost]). What kind of computation should total cost be according to best practise?
DISTINCTCOUNT( Regions[Country] ) would give you the number of unique countries.
When designing a query in Power BI Desktop, what is the best datatype to use for a column that contain currency values?
We have two tables 'Product' and 'Sales' with a relationship between them 1:1. We want to create a calculated column in the sales table for the division between sales price ('Sales'[SalesPrice]) and product price ('Product'[ProductPrice]). Which function is correct to use?
What data category setting should you use to geographically map column values to United States when the column contains values in city, state format such as Chicago, IL or Detroit, MI?
One of the following DAX expressions is wrong. Which one?

a) Date (2020, 4, 18) ;
b) Date(2020, 4, 18) + 30 =5/18/2020 ;
c) Date (2020, 4, 18) & 14 = "4/18/202014" ;
d) '10' & 32 = "1032"
DAX Scenarios Quiz
You got {{userScore}} out of {{maxScore}} correct
{{title}}
{{image}}
{{content}}

Return to DAX Quizzes