Which DAX formula should you use?

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

microsoft-exams

One thought on “Which DAX formula should you use?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.