Forum Discussion
Using a portion of a slicer
Hi, I really hope someone can help me with this, as I'm new to DAX queries and I've been searching for the answer for hours with no results. I have a slicer with a Month-Year picker, based of...
Possibly worth mentioning, if I edit the interactions and remove the interaction between the slicer and the chart, I can get what I want with the following measure:
CALCULATE(TOTALYTD(
SUM('Data'[Total Revenue]),
'Date Start'[Date], "30/06"
),'Date Start'[MonthName] = "July")
However, I don't want to have to go in and change the month all the time. I want the month to be linked to the slicer (but I don't want the year linked to the slicer).