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

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

A.
Option A

B.
Option B

C.
Option C

D.
Option D



Leave a Reply 9

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


Carlos Escobar

Carlos Escobar

C and D

Dim

Dim

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.

Fabio J.

Fabio J.

For me, A and D are correct.

Vikas Bansal

Vikas Bansal

IT is A,C and D. Confirmed.

dust

dust

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.

Ralph

Ralph

I agree A & D