Answer-first summary for fast verification
Answer: SELECTEDMEASURE()
The correct expression for creating a calculation item that changes the context to month-to-date (MTD) is CALCULATE(SELECTEDMEASURE(), DATESMTD('Date'[Date])). The SELECTEDMEASURE() function dynamically refers to the measure in the context it's being applied, and DATESMTD('Date'[Date]) calculates the dates from the beginning of the month to the current date within the filter context. Therefore, combining them inside the CALCULATE function correctly filters and calculates values for MTD.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are working with a Microsoft Power BI semantic model and are preparing to implement calculation groups to enhance your data analysis capabilities. As part of this task, you need to create a calculation item that modifies the current date context to reflect month-to-date (MTD) values. How should you complete the DAX expression to achieve this transformation?
CALCULATE(..., DATESMTD('Date'[Date]))
A
SELECTEDMEASURE()
B
SUM('Date'[Date])
C
AVERAGE('Date'[Date])
D
MAX('Date'[Date])
No comments yet.