Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 75 discussion

Actual exam question from Microsoft's 70-778

Question #: 75
Topic #: 1

You have a Power BI model that contains the following two tables:
✑ Assets (AssetID, AssetName, Purchase_DateID, Value)
✑ Date (DateID, Date, Month, Week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?

A. (sum(Assets[Value]) "" CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date])))/CALCULATE(sum(Assets[Value])), SAMEPERIODLASTYEAR("˜Date'[Date])))
B. CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date]))/ (sum(Assets[Value])
C. CALCULATE(sum(Assets[Value]),DATESYTD(("˜Date'[Date]))/ (sum(Assets[Value])
D. (sum(Assets[Value]) "" CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date]))/

Show Suggested Answer

Suggested Answer: D 🗳️

by maruthi_sharma at July 22, 2019, 12:24 p.m.

Comments

Submit Cancel

Orl

Highly Voted 5 years, 10 months ago

Should be A

upvoted 25 times

Hien

5 years, 10 months ago

Yes, I agree.

upvoted 2 times

Brunobsv

5 years, 6 months ago

As far as I understand A is dividing the same value as numerator and denominator. C seems to be the correct one for me. Although we don´t know the options well,cause they are not well formatted.

upvoted 4 times

Brunobsv

5 years, 6 months ago

correction B

upvoted 3 times

...

coupet

5 years, 5 months ago

Year-over-year Growth = [(This Year – Last Year) / Last Year] 100 Answer A = (current assets value - lastyear assets value)/lastyear assets value

upvoted 9 times

raspberry

5 years, 4 months ago

Agreed, A is correct. Suggested answer (D) is wrong.

upvoted 1 times

...

maruthi_sharma

Highly Voted 5 years, 10 months ago

D option seems to be incomplete :( Can someone comment on this?

upvoted 6 times

Hien

5 years, 10 months ago

can be like this? (sum(Assets[Value]) - CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR(Date[Date])))/ sum(Assets[Value])

upvoted 14 times

Hien

5 years, 10 months ago

it is incomplete, then correct answer should be A

upvoted 4 times

...

cs3122

5 years, 5 months ago

There is a typo in the answer, but if that "" was changed to a - then the formula would be correct. I suspect its a typo, and thus A is the correct answer

upvoted 8 times

...

CDL

Most Recent 4 years, 7 months ago

A is correct basis formula is % = (current/prior - 1) = (current - prior) / prior

upvoted 2 times

...

TONYSOCCER

4 years, 8 months ago

Check question 55 on this link https://biztics.com/70-778.pdf

upvoted 2 times

kyliek7

4 years, 7 months ago

nope, there is simple deduction, and we need to divide something to get %

upvoted 1 times

...

sabribrk

4 years, 8 months ago

D but you have to remove the / at the end

upvoted 1 times

...

camyla

4 years, 8 months ago

A is correct. The SAMEPERIODLASTYEAR() is used twice because to obtain the increase the division must be done by last year value. (Actual Value - Last Year Value) / Last Year Value (sum(Assets[Value]) - CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date])))/CALCULATE(sum(Assets[Value])), SAMEPERIODLASTYEAR("˜Date'[Date])))

upvoted 1 times

...

RJM9000

4 years, 11 months ago

Answer is C in my opinion. Let's check the Answer "...since one year ago". It's not requiring confronts among periods, but it's requiring the growth percentage in the last year...so we need DATESYTD function!

upvoted 2 times

...

Echicken69

4 years, 11 months ago

Finally got it to work. The Syntax is Total Assets Value Increase = (sum(TEST[Value]) - CALCULATE(sum(TEST[Value]),SAMEPERIODLASTYEAR(TEST[Date]))/CALCULATE(sum(TEST[Value]),SAMEPERIODLASTYEAR(TEST[Date]))). A is definitely wrong not only is the operators incorrect but the brackets ain't even in the right places. I tried it and I had to change where the brackets are located. So A will not work.

upvoted 3 times

123

4 years, 11 months ago

Makes sense, I suppose (I'm not saying you are wrong!) Just odd that if D, why incomplete? Regardless, based on what D says and the video indicates - probably correct. https://www.youtube.com/watch?v=rBqff_yINmc

upvoted 1 times

...

Echicken69

4 years, 11 months ago

How is either A or D correct? They both have wrong syntax operators?? D doesn't even make sense because it has a divide at the end so that's broken. A operators doesn't even make sense...what is "" and "~ that's not even operators in DAX? I've literally tried it on my physical computer and it doesn't work....none of these answers are correct. Admin needs to update these answers.

upvoted 1 times

...

Konsumer93

5 years, 2 months ago

correct Answer is D but the Syntax is broken. It should be: sum(Assets[Value]) / CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR('Date'[Date])) You devide the Total_Value_t / Total_Value_t-1 to get the % change.

upvoted 2 times

Konsumer93

5 years, 2 months ago

Correction it's A. Wasnt reading carefully.

upvoted 2 times

Ag2001

5 years, 2 months ago

A is not correct. If u look carefully , there are extra angular brackets here and there. and Syntax of calculate is wrong in denominator. there is extra bracket after the first argument.

upvoted 2 times

...

lozqt

5 years, 3 months ago

Response A is to me incorrect for two reasons : The Calculate fonction allows to perform calculations on certain conditions (calculate(sum([products] = "shoes" - to calculate the total for shoes only amongst other products). Hence no need to use calculate for total value (only need to filter a preferred date, with slicer, for the analysis). The function SAMEPERIODLASTYEAR is used twice in A. There is no coherent reason for this. To me B is correct as it divides the Sameperiodlastyear value / total value. I would even do this (sameperiodlastyear value/total value -1 to obtain the evolution %)

upvoted 3 times

...

Seyed

5 years, 4 months ago

A is true. (Current year - Last Year)/Last year

upvoted 6 times

Dirk

5 years, 3 months ago

No - maybe I'm confused about the strange spelling in the text, but I think that A does something else - so here my "fake code" of A: [Total Assets value]-[Filtered Assets value one year ago]/[Filtered Assets value one year ago] To make it easier to read: [Total Assets value] -(1/1) Am I wrong or struggle with it?

upvoted 2 times

...

mohroshdy

5 years, 5 months ago

A is correct

upvoted 5 times

...

JohnFan

5 years, 6 months ago

A. (sum(Assets[Value]) –CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(‘Date’[Date])))/CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (‘Date’ [Date])) B. CALCULATE(sum(Assets[Value]) DATESYTD (‘Date’[Date]))/sum(Assets[Value]) C. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (‘Date’ [Date]))/sum(Assets[Value]) D. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (‘Date’ [Date]))

upvoted 2 times

AnetaK

5 years, 6 months ago

So A is correct.

upvoted 4 times

...