Exam 70-778 topic 2 question 10 discussion

Actual exam question from Microsoft's 70-778

Question #: 10
Topic #: 2

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

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

Submit Cancel

patfitz

Highly Voted 6 years, 2 months ago

A is the correct answer

upvoted 44 times

...

Echicken69

Most Recent 5 years 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

5 years, 3 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