Microsoft
70-466 · Question #117
70-466 Question #117: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
Build a tabular data model
Question
You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to define a measure named Profit and include a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates. You need to create a measure to report on year-over-year growth of profit. What should you do? (Each answer presents a complete solution. Choose all that apply.)
Options
- ADEFINE the following calculation. Year Over Year Revenue Growth:=[Revenue] - CALCULATE([Revenue], SAMEPERIODLASTYEAR('Date'[Date]))
- BDEFINE the following calculation. Year Over Year Revenue Growth:=CALCULATE([Revenue], DATEADD('Date'[Date], 1, YEAR))
- CUse the Business Intelligence Wizard and then use the Define time intelligence enhancement.
- DDEFINE the following calculation. Year Over Year Revenue Growth:=[Revenue] - CALCULATE([Revenue], PARALLELPERIOD('Date'[Date], -12, MONTH))
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DAX time intelligence#SAMEPERIODLASTYEAR#PARALLELPERIOD#year-over-year growth