Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 36 discussion

Actual exam question from Microsoft's PL-300

Question #: 36
Topic #: 2

HOTSPOT -
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: CALCULATE -
Calculate the sum.

Box 2: DATEADD -
DATEADD -1 QUARTER will give the previous month.

Box 3: DIVIDE -
Use DIVIDE to get the relative change.

by Namenick10 at Sept. 21, 2022, 3:01 p.m.

Comments

Submit Cancel

Namenick10

Highly Voted 2 years, 9 months ago

1. Calculate 2. Dateadd 3. Divide

upvoted 138 times

GuerreiroJunior

2 years, 5 months ago

I totally agree with you Nick10

upvoted 6 times

ggsss

1 year, 2 months ago

And I agree with you Junior

upvoted 3 times

paras97

1 year, 2 months ago

I agree with you ggsss!

upvoted 3 times

e31df62

1 year ago

I agree with you Paras97

upvoted 1 times

cf39210

1 year ago

And i agree with you e31df62

upvoted 1 times

...

lukelin08

Highly Voted 2 years, 8 months ago

Calculate Dateadd Divide

upvoted 21 times

...

rcaliandro

Most Recent 10 months ago

1 - CALCULATE 2 - DATEADD 3 - DIVIDE That's correct

upvoted 2 times

rcaliandro

10 months ago

Tested =)

upvoted 1 times

...

Jaitan

1 year, 3 months ago

Is missing a denomiator on Divide? I don't get it.

upvoted 2 times

Mo_Suhail

6 months, 3 weeks ago

We don't get denominator while using DIVIDE(4,2) gives you 2. It works like this.

upvoted 1 times

...

steppenwolf84

1 year, 2 months ago

Numerator is the first argument i.e. SUM('financials'[Sales])-PREV_QUARTER. Denominator is the second argument i.e. PREV_QUARTER https://learn.microsoft.com/en-us/dax/divide-function-dax

upvoted 1 times

...

Igetmyrole

1 year, 9 months ago

Calculate Dateadd Divide

upvoted 3 times

...

rgabage

1 year, 9 months ago

CALCULATE, DATEADD, DIVIDE

upvoted 2 times

...

EwoutBI

1 year, 10 months ago

There is a small typo in the DATEADD part, but apart from that the given answer is correct. Here it is typed out for easy reference: Sales QoQ% = IF(ISFILTERED('FACT_Order'[Date]), ERROR("Oh noes"), VAR PREV_QUARTER = CALCULATE(SUM(FACT_Order[OrderID]), DATEADD(FACT_Order[Date], -1, QUARTER)) RETURN DIVIDE(SUM(FACT_Order[OrderID]) - PREV_QUARTER, PREV_QUARTER)) (I used a fact order table to calculate this.)

upvoted 3 times

...

miro26

1 year, 10 months ago

As for the correctness of the functions used, the measure is Ok, but does this measure count what is required? According to this mesure, current sales are the sum of the contents of the entire table minus the previous quarter. When Q3 is current, we divide the sum of Q1 and Q3 by Q2. Shouldn't it be DIVIDE(Q3,Q2) ?

upvoted 1 times

...