DP-500 Question #65: Real Exam Question with Answer & Explanation

The correct answer is E: DATESYTD. To calculate a fiscal prior year-to-date measure for sales amount with a specific fiscal year end, the DATESYTD DAX function is the appropriate choice.

Implement and manage data models

Question

You are building a Power BI dataset with a Calendar table and a calculated column `pfFlag = IF ('Calendar'[Date] < TODAY(), "Past", "Future")`. You need a measure for fiscal prior year-to-date for [sales Amount], with a fiscal year end of June 30, producing no result for future dates. How should you complete the DAX expression, specifically the function for year-to-date calculation with fiscal year end '6/30/2022' from the provided options?

Options

ADATEADD
BFIRSTDATE
CPARALLELPERIOD
DSAMELASTPERIODLASTYEAR
EDATESYTD

Explanation

To calculate a fiscal prior year-to-date measure for sales amount with a specific fiscal year end, the DATESYTD DAX function is the appropriate choice.

Common mistakes.

A. DATEADD shifts a set of dates by a specified interval and is not designed for year-to-date calculations.
B. FIRSTDATE returns the first date in the current filter context and is not used for aggregating year-to-date values.
C. PARALLELPERIOD returns a set of dates in a parallel period to the given set of dates, suitable for comparisons but not for year-to-date aggregation.
D. SAMELASTPERIODLASTYEAR returns a set of dates in the previous year of the same period, but it does not support custom fiscal year ends for YTD calculations.

Concept tested. DAX DATESYTD fiscal year-to-date calculation

Reference. https://learn.microsoft.com/en-us/dax/datesytd-function-dax

Topics

#DAX#Time Intelligence#Fiscal Year#Measures

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice Browse All DP-500 Questions