DP-500 · Question #30
DP-500 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock DP-500 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
You have a Power BI dataset that contains the following measure. YTD Year-over-Year Var = DIVIDE ( ( [Sales Amount] - CALCULATE ( [Sales], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ), 'Calendar'[Flag] = "YTD" ) ), CALCULATE ( [Sales], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ), 'Calendar'[Flag] = "YTD" ), BLANK() ) You need to improve the performance of the measure without affecting the logic or the results. What should you do?
Options
- AReplace both calculate functions by using a variable that contains the calculate function.
- BRemove the alternative result of blank( ) from the divide function.
- CCreate a variable and replace the values for [Sales Amount].
- DRemove "calendar[Flag] = "YTD" from the code.
Unlock DP-500 to see the answer
You've previewed enough free DP-500 questions. Unlock DP-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.