Exam PL-300 topic 2 question 80 discussion

Actual exam question from Microsoft's PL-300

Question #: 80
Topic #: 2

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

A. CALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) )
B. CALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )
C. TOTALQTD ( [Total Sales], Date[Date] )
D. CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )

Show Suggested Answer

Suggested Answer: A 🗳️

by tranquanghuy2111 at Oct. 8, 2023, 1:34 p.m.

Comments

Submit Cancel

tranquanghuy2111

Highly Voted 1 year, 8 months ago

DATEADD is correct. PARALLELPERIOD also calculate one quarter before, but the out come is the total sales of three months of previous quarter not only one day or one month of previous quarter

upvoted 20 times

ZillowGosia

1 year, 7 months ago

A is correct.

upvoted 7 times

...

Koalakueh

Highly Voted 1 year, 7 months ago

Selected Answer: A

we can use PARALLELPERIOD() as well. It's just that the option for that is 1 year later rather than 1 year earlier

upvoted 8 times

539d541

9 months, 4 weeks ago

I think the answer D is 1 quarter later, not earlier as required. Other than that I think you're correct that it would have been ok too

upvoted 1 times

...

LeeTheRed

1 year, 6 months ago

Good observation!

upvoted 1 times

...

5bf040d

Most Recent 3 months, 1 week ago

Selected Answer: A

The correct answer is A because the question mentioned previous quarter, so that, -1 Parallelperiod will work but if it would have 1 instead of -1 CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], -1, QUARTER ) )

upvoted 1 times

...

jaume

7 months ago

Selected Answer: A

B. QTD would return "Quarter To Date" result not previous year C. Again it's about QTD D. if you doubt about the PARALLELPERIOD, note the step is 1 not -1 so it would be not the previous quarter but next one A. with DATADD function using a negative (-1) step, we are referring to the previous quarter

upvoted 2 times

...