Exam PL-300 Topic 2 Question 253 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 253
Topic #: 2
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Suggested Answer:


Explanation:

Box 1: A DAX Calculated measure
Box 2: Date.EndofQuarter(#date([Year],[Mont],1))
ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates.
The following sample formula creates a measure that returns the end of the quarter, for the current context.
= ENDOFQUARTER(DateTime[DateKey])
Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

by Adelaide at Jul 09, 2026, 03:02 AM

Limited Time Offer

15%

Off

Get Premium PL-300 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10