PrepAway - Latest Free Exam Questions & Answers

You need to create a measure to report on year-over-yea…

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

PrepAway - Latest Free Exam Questions & Answers

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

One Comment on “You need to create a measure to report on year-over-yea…


Leave a Reply