Exam DP-500 topic 1 question 105 discussion

Actual exam question from Microsoft's DP-500

Question #: 105
Topic #: 1

HOTSPOT -
You are building a Power BI dataset that contains a table named Calendar. Calendar contains the following calculated column.

You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
Returns the fiscal prior year-to-date value for [Sales Amount]
Uses a fiscal year end of June 30
Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by MM_GG at Dec. 21, 2022, 1:29 p.m.

Comments

Submit Cancel

MM_GG

Highly Voted 2 years, 6 months ago

pfFlag would either be Future or Past, so seems redundant to filter on TODAY(), imo should be "Past"

upvoted 14 times

stfglv

2 years, 5 months ago

My thoughts exactly. Or, looking from another angle, why would the pfFlag be mentioned and explained at all if one of its outcome values (Future/Past) is not part of the solution?

upvoted 2 times

...