ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 2 question 10 discussion

Actual exam question from Microsoft's 70-778
Question #: 10
Topic #: 2
[All 70-778 Questions]

You have a power BI model that contains the following tables:
✑ Assets( AssetsID, AssetName, Purchase_DateID, Value)
✑ Date( DateID, Date, Month, Week, Year)
The tables have 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. CALCULATEx(sum(Assets[Value]) DATESYTD (Date[Date]))/ sum(Assets[Value])
  • C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR (Date [Date]))
  • D. CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR (Date [Date]))/
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
References:
https://msdn.microsoft.com/en-us/library/ee634825.aspx
https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics https://msdn.microsoft.com/en-us/library/ee634972.aspx
by patfitz at April 26, 2019, 9:52 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
patfitz
Highly Voted 5 years, 7 months ago
A is the correct answer
upvoted 44 times
...
Echicken69
Most Recent 4 years, 5 months ago
C just gives you a number... ain't we meant to be calculating the percentage? How is the answer not A?
upvoted 1 times
...
Jrestrepo
4 years, 8 months ago
I validated A and C. A gave an error "infinity" maybe because there was a year with no sales. and C gave me the difference between ThisYear and LastYear Sales. D is missing part of the Formula, and B as obviously not the answer. This is so frustrating. The below formula worked for me: % Sales Increase = ([TotalSalesLY] /[TotalSalesTY]) Where TotalSalesLT = CALCULATE(Sum(FactInternetSales[SalesAmount]),SAMEPERIODLASTYEAR(DimDate[FullDateAlternateKey])) and TotalSalesTY = Sum(FactInternetSales[SalesAmount]) and
upvoted 3 times
Jrestrepo
4 years, 8 months ago
Tip* for the % Sales Increase measure make it 3 decimal points.
upvoted 1 times
...
...
Delta
4 years, 11 months ago
A is correct, C is not a % What is supposed to be the complete formula at D ?
upvoted 1 times
...
mohroshdy
4 years, 11 months ago
A is correct
upvoted 4 times
...
AnetaK
5 years ago
"calculate the percentage that the total assets value increased since one year ago" So it should by (CY-PY) / PY. There is no such answer.
upvoted 4 times
AnetaK
5 years ago
Ok, A is the correct answer.
upvoted 6 times
...
PowerLjubica
4 years, 6 months ago
I agree with the formula. Answer A is written this way. The same thing would be (CY/PY)-1.
upvoted 2 times
...
...
Brunobsv
5 years, 1 month ago
how can the formula in C calculate the percentage ?
upvoted 2 times
...
3water
5 years, 3 months ago
obviously, C is wrong
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago