Forum Discussion
Solved
Month Slicer Not Working with Year Calculation
Hello - I cannot figure out how to get the month slicer to work with 2 measures I have created for 2024 & 2025 Sales. I want to be able to just select January or January & February and have the 2025 ...
2025 Spend = CALCULATE(SUM('Combined Spend Data'[Total]),KEEPFILTERS(Year(Calendar[Date])=2025)) 2024 Spend = CALCULATE(SUM('Combined Spend Data'[Total]),KEEPFILTERS(Year(Calendar[Date])=2024))
2025 Spend = CALCULATE(SUM('Combined Spend Data'[Total]),KEEPFILTERS(Year(Calendar[Date])=2025))
2024 Spend = CALCULATE(SUM('Combined Spend Data'[Total]),KEEPFILTERS(Year(Calendar[Date])=2024))