Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 53 discussion

Actual exam question from Microsoft's 70-778

Question #: 53
Topic #: 1

HOTSPOT -
You have the report shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

by TiaanR at July 9, 2019, 12:07 p.m.

Comments

Submit Cancel

TiaanR

Highly Voted 5 years, 11 months ago

Based on the table definition, the max value is 0.5

upvoted 39 times

...

Richa

Highly Voted 5 years, 8 months ago

I think it is new parameter and max values is 0.5

upvoted 20 times

mirzotti

5 years, 6 months ago

You are correct. I have recreated the test. When using New Parameter it automatically creates GENERATESERIES function. Second, in GENERATESERIES function the second parameter is the max value which is 0,5.

upvoted 3 times

...

Lhouss

Most Recent 4 years, 6 months ago

New Parameter (what if parameter) 0.5

upvoted 2 times

...

Porge

4 years, 6 months ago

If you look in the graphic, there is no Parameter available! This was probably created before the What If Parameter was created, therefore in this instance, it must be New Table and 0.5. I can only assume that there would be more than one correct answer if both Table and Parameter were available.

upvoted 1 times

...

Lhouss

4 years, 6 months ago

Table definition, max value is 0.5

upvoted 1 times

...

CDL

4 years, 7 months ago

what if Parameter & 0.5 Link: https://www.youtube.com/watch?v=NKIcDpSdLc4 https://docs.microsoft.com/en-us/dax/generateseries-function

upvoted 2 times

...

KR1998

4 years, 8 months ago

This is a What-if parameter.

upvoted 2 times

...

meganx

4 years, 9 months ago

I tested in Power BI, 0.5 is correct.

upvoted 1 times

...

eug45

4 years, 9 months ago

New Parameter and 0.5 https://www.youtube.com/watch?v=53tOqKG3W7I&t=202s

upvoted 1 times

...

eug45

4 years, 9 months ago

The answer is new parameter and 0.5 https://www.absentdata.com/power-bi/parameter-power-bi/

upvoted 2 times

...

borut

4 years, 10 months ago

The big problem here is that the column Discount[Discount] (and Discount[Discount Value]) can be created automatically by What-If parameter or manual with Calculated table. If you use What-If parameter, you automatically get two columns, Discount[Discount] and Discount[Discount Value], not Discount[Discounted Value]. Here must be a trick. We newer know!

upvoted 1 times

Steviyke

4 years ago

I think you are right. 1) look at the icon for Discount[Discount] in the Fields pane -- it is clearly a table icon. 2) If a "what-if" parameter was used, like you said, Discount[Discount Value] will be created Automatically, not Discount[Discounted Value]. Though one can argue that the name could be changed after creation but I believe that isn't the case here. So going by the available info in the question, it a TABLE and highest value is 1. reason being that StartValue is 0, if EndValue (Highest value) is 0.5, IncrementValue CANNOT be 1. So series starts at 0, increments by 0.5 and ends in 1.

upvoted 1 times

...

r8d1

4 years, 11 months ago

New table 0.5 syntax: GENERATESERIES(<startValue>, <endValue>[, <incrementValue>]) Returns: A table containing the values of an arithmetic series in a single column.

upvoted 5 times