Microsoft
70-768 · Question #55
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…
The correct answer is C. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], D. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit]. See the full explanation below for the reasoning.
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],
How the community answered
(32 responses)- A13% (4)
- B6% (2)
- C81% (26)
Community Discussion
No community discussion yet for this question.