Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 80 discussion

Actual exam question from Microsoft's 70-779

Question #: 80
Topic #: 1

You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula.
([Total Sales Current Year] "" [Total Sales Last year]) / [Total Sales Last Year]
Total Sales Current Year is a measure that calculates the sales from the current calendar year. Total Sales Last Year is a measure that calculates the sales from the previous calendar year.
You need to create a KPI that displays a red icon when the sales growth is less than last year.
What should you use to define the target value?

A. the Total Sales Current Year measure
B. an absolute value of 0
C. the Total Sales Last Year measure
D. an absolute value of 100

Show Suggested Answer

Suggested Answer: C 🗳️
Reference:
https://support.office.com/en-us/article/key-performance-indicators-kpis-in-power-pivot-e653edef-8a21-40e4-9ece-83a6c8c306aa

by excelll at Oct. 28, 2019, 12:31 a.m.

Comments

Submit Cancel

excelll

Highly Voted 5 years, 8 months ago

shouldnt it be absolute value of zero since it is comparing against a percentage?

upvoted 10 times

Tr4ckz

5 years, 6 months ago

Agreed. The SalesGrowth measure will give us a % value of e.g. +1.5% if there is a growth, or -2% if it's less. You can't compare the % value to absolute € numbers but 0 as a target will work fine, as it's only "not achieved" if there is no growth but loss, or growth values < 0

upvoted 13 times

FrdFrd

4 years, 5 months ago

The writing for this question is ambiguos. The goal is: "You need to create a KPI that displays a red icon when the sales growth is less than last year." (???) First of all, I think the writing should be either "when the current year SALES is less than the last year's" or "when there is negative or no SALES GROWTH". Second: the question doesn't clealy mention whether the KPI will be based on the sales growth measure or on the current year sales. Assuming that it will be based on the sales growth (it seems that was the intention) the correct answer would be B. But if the KPI will be based on the current sales then the correct answer would be C. I would bet that the intention is that the KPI will be based on sales growth and choose B

upvoted 1 times

...

SumanthB

Highly Voted 5 years, 4 months ago

If the Last Year Sales was 1.5 million up to a certain month and this years sale up to the same month as last year is 2 million, then (2-1.5)/1.5 = .33 or 33% - doesnt make sense to compare the value .33 which is growth to 1.5 million which is last year sales amount calculated by the measure.

upvoted 5 times

...

CDL

Most Recent 4 years, 8 months ago

Tested, B is correct, absolute value 0 should be target value. Current/prior year sales used DAX : SUMX(FILTER(table, table[xx] = “current/prior year”), expression) Fx means measure here. Totally 3 measures here. Sales growth% Fx = (current Fx – prior Fx)/prior Fx KPI = sales growth % Fx, as we can see in the formula, if current Fx = prior Fx, the sales growth% =0, so 0 should be target value. And I already tested, it worked.

upvoted 1 times

...

r8d1

4 years, 11 months ago

Ans: C I think the 'absolute value' is misleading. I read this a KPI to compare This Year's Total to Last Year’s Total, set as a target.

upvoted 2 times

stv

4 years, 11 months ago

IMO C is correct. The measure [SalesGrowth] is the percentage of the sales growth. Also if [Total Sales Current Year] are less than [Total Sales Last Year] the sales growth is less, so having the [Total Sales Last Year] as target makes sense.

upvoted 1 times

...

PowerLjubica

5 years ago

Does anyone understand the following: ([Total Sales Current Year] "" [Total Sales Last year]) / [Total Sales Last Year] ?!

upvoted 1 times

ammu

5 years ago

([Total Sales Current Year] - [Total Sales Last year]) / [Total Sales Last Year]

upvoted 3 times

...

CibrevN

5 years ago

B. an absolute value of 0. I have checked

upvoted 3 times

...

daxy2020

5 years, 1 month ago

C is the correct answer. The question clearly shows that you have all the MEASURES that can help you for creating a KPI. You just need to use these measures as Value(Base Line) and Target to create a KPI that displays a red icon when the sales growth is less than last year.

upvoted 4 times

...

claudia_learner

5 years, 2 months ago

I think the correct answer is not included in the choices. The question asks that the KPI shall compare the sales growth (not the sales) against the sales growth (not the sales) from last year. SECOND derivative. Just evaluating whether SalesGrowth is <0 , 0 or >0 gives you the FIRST derivative (sales this year compared to sales last year). So you need the Previous Year SalesGrowth as target.

upvoted 3 times

PowerBIconsultant12

4 years, 8 months ago

I can see your point. I think the one who created the question was maybe not that sharp as you are. But in the beginning of the text they are calculation [total sales current year] and [total sales last year] => therefore in this case I will go with answer C.

upvoted 1 times

sjonghe

4 years, 7 months ago

The correct answer is still included. Even if you should compare the sales growth of this year (this years sales compared to last years sales) with the sales growth of last year (last years sales compared to sales 2 years ago) by creating a new measure on top of this, even then you need to place an absolute value of '0' as the target.

upvoted 1 times

...

Jrestrepo

5 years, 2 months ago

Why could you not use the measure [total sales current year] as the target

upvoted 2 times

PowerBIconsultant12

4 years, 8 months ago

because then you would never have any sales growth. If you always compare [total sales current year] with [total sales current year] you will always have 100% (or 0% growth) as the answer. The target value is the [total sales last year]. Then is you exceed that you can have for example a 5% growth because you exceeded the target sales.

upvoted 1 times

...

Olivia

5 years, 4 months ago

Go with B.

upvoted 3 times

Mounira

4 years, 5 months ago

we are talking about % of growth , so target value is 0. Answer is B

upvoted 1 times

...