Exam PL-300 topic 2 question 71 discussion

Correct Answer To create a calculated table named Numbers in Power BI Desktop that contains all the integers from -100 to 100, you can use the following DAX calculation: Numbers = GENERATESERIES(-100, 100, 1) Explanation: The GENERATESERIES function generates a table of values that starts at the first argument (-100), ends at the second argument (100), and increments by the third argument (1) in this case. The resulting table will contain all the integers from -100 to 100 inclusive. The calculated table is named "Numbers" and is created by assigning the output of the GENERATESERIES function to it using the "=" operator. No confusion, and no need to discuss further

Correct! GENERATESERIES - (-100,100,1)

GENERATESERIES is the only function in the list accepting 3 parameters. GENERATE (<Table1>, <Table2 Expression>] would crete a virtual table pairing rows of 2 tables where the second table depends on the current row of first table GENERATEALL(<table1>, <table2 expression>) similar to GENERATE but it will include rows even when first table is empty GENERATESERIES(<start>, <end>, [<step>] creates a single-column table of values within a numeric range

The answer is correct!

GenerateSeries uses 3 arguments, lower value, upper value, step (from -100 to 100 increment by 1) Generate(table1, table2) creates a new table with cartesian products (for each row in table 2 add all rows from table1) If table1 has 2 records and table 2 has 3 records, new table will have 2X3=6records BY RECORD ORDER OF TABLE 1 t1 t2 1 1 2 1 1 2 2 2 1 3 2 3 GenerateAll(table1, table2) creates a new table with cartesian products (for each row in table 1 add all rows from table2) If table1 has 2 records and table 2 has 3 records, new table will have 2X3=6records BY RECORD ORDER OF TABLE 2 t1 t2 1 1 1 2 1 3 2 1 2 2 2 3 Generate and GenerateAll use the same principle as multidimension arrays

Correct Answer given

Generateseries (-100,100,1) This formula generates a serious of numbers starting from -100, ending at 100, with an increment of 1.

Correct Numbers = GENERATESERIES(-100, 100, 1) Start -100 End 100 Increment 1

Correct. GENERATESERIES(-100, 100, 1)

GENERATESERIES function will generate a table of integers from the starting value (-100) to the ending value (100), with an increment of 1. This table will be returned as a new calculated table named "Numbers".

Correct