Câu 42: 70-778: Analyzing and Visualizing Data with Microsoft Power BI

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?

1. A. (sum(Assets[Value]) "" CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date])))/CALCULATE(sum(Assets[Value])), SAMEPERIODLASTYEAR("˜Date'[Date])))
2. B. CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date]))/ (sum(Assets[Value])
3. C. CALCULATE(sum(Assets[Value]),DATESYTD(("˜Date'[Date]))/ (sum(Assets[Value])
4. D. (sum(Assets[Value]) "" CALCULATE(sum(Assets[Value]), SAMEPERIODLASTYEAR("˜Date'[Date]))/ — đáp án hiện tại