Microsoft
70-768 · Question #55
70-768 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes 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
- AUse the Business Intelligence Wizard and then use the Define time intelligence enhancement.
- BDefine the following calculation. Year Over Year Profit Growth:=CALCULATE([Profit],
- CDefine the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit],
- DDefine the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit],
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 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.