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.
Option A
B.
Option B
C.
Option C
D.
Option D