You need to create a measure to report on year-over-year growth of profit

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.)

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))



Leave a Reply 1

Your email address will not be published. Required fields are marked *