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.)
A.
Use the Business Intelligence Wizard and then use the Define time intelligence enhancement.
B.
Define the following calculation. Year Over Year Profit Growth:=CALCULATE([Profit], DATEADD
(‘Date'[Date], 1, YEAR))
C.
Define the following calculation. Year Over Year Profit Growth:=[Profit] – CALCULATE([Profit],
SAMEPERIODLASTYEAR(‘Date'[Date]))
D.
Define the following calculation. Year Over Year Profit Growth:=[Profit] – CALCULATE([Profit],
PARALLELPERIOD(‘Date'[Date], -12, MONTH))
C
D