Analyzing and Visualizing Data with Microsoft Power BI — Question 36

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?

Answer options

• 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]))/

Correct answer: D

Explanation

The correct answer is D because it correctly calculates the difference between the current total asset value and the asset value from the same period last year, then divides that difference by the previous year's total to get the percentage increase. Options A, B, and C either contain syntax errors or do not correctly perform the necessary calculations to find the percentage increase.