Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Easy
Question 38
In Power BI Desktop, you need to create a calculated table that contains a single column of three-digit even numbers. Which of the following DAX formulas would you use?
-
A
GENERATESERIES (100,999)
-
B
GENERATESERIES (999,100)
-
C
GENERATESERIES (100,1000,-2)
-
D
GENERATESERIES (100,999,2)
Reveal correct answer
Correct answer: D
Explanation
The GENERATESERIES DAX function returns a table with a single column. It takes three parameters:
1. The first parameter is the beginning value of the series
2. The second parameter is the last value of the series
3. The third optional parameter is the incremental value.
Option D is the correct answer as it creates a table that begins from 100 to 998, with increments of 2.
Option C is incorrect as it includes a 4-digit even number (1000). Further, the incremental value cannot be negative, so this formula returns an error.
Option B returns an empty table because the end value is less than the start value.
If no incremental value is provided, the default value 1 is used. So, the formula in option A returns all numbers from 100 to 999. Check the PBIX file for the output.
Reference Link: https://dax.guide/generateseries/
PBIX File Link: Calculated table with three-digit even numbers
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
