ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 113 discussion

Actual exam question from Microsoft's PL-300
Question #: 113
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer: B 🗳️
by c034d75 at Feb. 16, 2025, 11:29 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
gpsaran
1 week, 2 days 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 2 times
nlnlznlx
3 days, 7 hours ago
Agree, I tested. PREVIOUSYEAR returns Jan 1, 2023 - Dec 31, 2023 DATESYTD() returns sales from Jan 1, 2023 - May 9, 2023
upvoted 1 times
...
...
4b88f2d
1 week, 3 days ago
Selected Answer: C
I think is C too, because the key as Anloindian said: PREVIOUSYEAR pulls anything from 2023 to the date they give us.
upvoted 1 times
...
Anloindian123
2 weeks ago
Selected Answer: C
I agree with C. PREVIOUSYEAR pulls anything from 2023 up to May 9th 2023. SAMEPERIODLASTYEAR is what results in option B
upvoted 2 times
...
Jasmine121
3 weeks ago
Selected Answer: C
I vote for C
upvoted 1 times
...
c034d75
3 weeks, 5 days ago
Selected Answer: B
The correct option is B, because it relates to the previous year date which is May 9, 2023.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago