You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model defines a measure named Profit and includesa 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 usethe 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))
CD Answer is correct.
To use DATEADD Dax function it should be:
=DATEADD(DateTime[DateKey],-1,year)
https://msdn.microsoft.com/en-us/library/ee634905.aspx
There is no Business Intelligence Wizard in tabular model.