Exam 70-778 topic 1 question 89 discussion

Actual exam question from Microsoft's 70-778

Question #: 89
Topic #: 1

DRAG DROP -
You have the following two tables:
✑ Subscriber (SubscriberID, EnrollmentDate, ServicePlan)
✑ Date (Date, Month, Week, Year)
There is a relationship between Subscriber[EnrollmentDate] and Date [Date].
You plan to create a KPI for the number of subscribers enrolled in the current year.
You need to create a goal that is five percent more than the number of subscribers enrolled during the previous calendar year.
How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Note: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

by CorinnaK at Oct. 24, 2019, 9:13 a.m.

Comments

Submit Cancel

CDL

4 years, 7 months ago

correct. PreviousYear: https://docs.microsoft.com/en-us/dax/previousyear-function-dax ParallelPeriod: https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax

upvoted 1 times

...

tinknerd

4 years, 10 months ago

parellelperiod returns the full period

upvoted 1 times

...

SamuelZhang

5 years ago

Why not parallelperiod?

upvoted 1 times

durian

4 years, 10 months ago

because PARALLELPERIOD is using this syntax: PARALLELPERIOD(<dates>,<number_of_intervals>,<interval>) e.g : PARALLELPERIOD(DateTime[DateKey],-1,year

upvoted 2 times

...

CYRUSD

5 years, 1 month ago

Since we have to return count of (previous year customer) multiplied by 1.05% . We dont need current year count (because the goal is based on previous year) . So Answer is correct

upvoted 1 times

...

coupet

5 years, 5 months ago

PREVIOUSYEAR : Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context.

upvoted 2 times

coupet

5 years, 1 month ago

PREVIOUSYEAR(<dates>[,<year_end_date>]) dates A column containing dates. year_end_date (optional) A literal string with a date that defines the year-end date. The default is December 31.

upvoted 1 times

...

CorinnaK

5 years, 7 months ago

In my opinion this doesn't work. But I am not sure about the correct answer. Can anybody help?

upvoted 1 times

CorinnaK

5 years, 7 months ago

found the problem in my measure, now it works. so the answer is correct

upvoted 3 times

...