Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 113 discussion

Actual exam question from Microsoft's PL-300

Question #: 113
Topic #: 2

You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

Model1 contains the following measure.

Previous Year Sales = CALCULATE([Sales Amount], PREVIOUSYEAR('Date'[Date]))

You have a report that uses Model1. The report has a single report page that has a page level filter set to May 9, 2024. The result of the Previous Year Sales measure is displayed in a card visual.

Which value will appear in the card visual?

A. 10
B. 15
C. 35
D. 60

Show Suggested Answer

Suggested Answer: D 🗳️

by c034d75 at Feb. 16, 2025, 11:29 p.m.

Comments

Submit Cancel

gpsaran

Highly Voted 5 months ago

Selected Answer: D

should it not be 60 because Previousyear calculates for complete calendar year from last year? Even Power BI calculates like that in a matrix.

upvoted 10 times

nlnlznlx

4 months, 3 weeks ago

Agree, I tested. PREVIOUSYEAR returns Jan 1, 2023 - Dec 31, 2023 DATESYTD() returns sales from Jan 1, 2023 - May 9, 2023

upvoted 2 times

...

c034d75

Highly Voted 5 months, 2 weeks ago

Selected Answer: B

The correct option is B, because it relates to the previous year date which is May 9, 2023.

upvoted 6 times

...

Lulu_2022

Most Recent 1 month, 1 week ago

Selected Answer: B

…the function shifts the date context to May 9, 2023. So unless your [Sales Amount] measure is doing something more complex, the value shown in the card will reflect the total sales from only that specific day: May 9, 2023. And in your case, that total is 15. If you wanted to compare entire months or rolling periods, you'd need to adjust the time intelligence function — perhaps using SAMEPERIODLASTYEAR over a visual that's filtered to May 2024 as a whole. Because the filter was set to a specific day then it will only get 15.

upvoted 1 times

...

Mkymp

2 months, 1 week ago

Selected Answer: B

In a single-date context, PREVIOUSYEAR ≈ SAMEPERIODLASTYEAR But in broader contexts (e.g., month, year), they differ.

upvoted 1 times

...

Trixy

2 months, 1 week ago

Selected Answer: D

It returns 60 as PREVIOUSYEAR( ) returns a table with all dates from the previous year.

upvoted 1 times

...

LuisViotti

2 months, 3 weeks ago

Selected Answer: B

Answer is B 15, cheked with chatgpt. Here the explanation: The correct answer is B. 15 The page filter is set to May 9, 2024, so the PREVIOUSYEAR('Date'[Date]) calculation will be applied to the same day in the previous year, i.e., May 9, 2023.

upvoted 1 times

...

e63be54

2 months, 4 weeks ago

Selected Answer: D

D because PREVIOUSYEAR takes May, 1 2023 (20) + May 9, 2023 (15) + May 29, 2023 (25) to get 60

upvoted 1 times

...

tytusss

3 months ago

Selected Answer: D

checked with chatgpt

upvoted 1 times

...

Data_Island

3 months, 1 week ago

Selected Answer: B

I believe the answer is still B. Its true PREVIOUSYEAR calculates the complete calendar year from last year but since there is a page-level filter set to May 9, 2024, it will return the specific date one year earlier which is May 9, 2023 acting similarly to SAMEPERIODLASTYEAR If there was no filter, then the answer would be 60.

upvoted 2 times

...

b92fc92

3 months, 3 weeks ago

Selected Answer: D

I think is D, 15 is the result with SAMEPERIODLASTYEAR()

upvoted 2 times

...

5bf040d

4 months, 3 weeks ago

Selected Answer: B

The PREVIOUSYEAR function does not sum all values up to May 9, 2023. Instead, it shifts the filter context to the entire previous year relative to the current filter context. Since the filter context is restricted to May 9, 2024, the PREVIOUSYEAR function shifts the filter to May 9, 2023.

upvoted 3 times

...