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

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 value for the `Calendar'[pfFlag]` filter, to produce no result for future dates?

Options

• A"Future"
• BNOW()
• C"Past"
• DTODAY()

Explanation

To ensure the measure produces no result for future dates, the DAX expression should filter or check the pfFlag column to exclude or handle "Future" values from the calculation context.

Common mistakes.

• B. NOW() returns the current date and time, which is not a valid filter value for the string pfFlag column.
• C. "Past" is the value for dates before today; filtering by "Past" would include historical data, not exclude future data.
• D. TODAY() returns the current date, which is not a valid filter value for the string pfFlag column.

Concept tested. DAX filtering for date flags

No community discussion yet for this question.