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
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00425.jpg
BC
B not working at day level.
A could be correct is we add [Profit]-….
C is correct.
D as per my knowledge there is no BI wizard in Tabular
PARALLELPERIOD not working on day period is not a problem here.
We need to implement year-over-year measure, so: B & C
there is now business intelligence wizard in tabular?
I dont think so.
In tabular models, although there is no wizard to create time intelligence calculations, you can manually create calculations by creating DAX formulas that leverage a variety of functions including TOTALMTD and TOTALYTD as well as SAMEPERIODSLASTYEAR. The key thing here to remember is that the table used for your date dimension must be set as a “date” table for the DAX date functions to work properly.
http://falconteksolutionscentral.com/?p=865