PrepAway - Latest Free Exam Questions & Answers

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

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines
a measure named Revenue 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 revenue.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

PrepAway - Latest Free Exam Questions & Answers

A.
Option A

B.
Option B

C.
Option C

D.
Option D

9 Comments on “You need to create a measure to report on year-over-year growth of revenue

  1. Dim says:

    Where i can launch Business Inteligence Wizard in Tabular Model?

    A- correct

    B- correct if you add [Revenue]-calculate…

    C-?

    D-Wrong -not working at day level cause parellelperiod brings all days at month level.




    0



    0
  2. dust says:

    It is A & D only.
    There is no wizard for defining time intelligence in Tabular Models.

    You are simply marking as a date table. as per link Briquet’s reply

    The Business Intelligence Wizard for Multidimensional only.




    0



    0

Leave a Reply