Previous YTD with Week Number slicer interaction

Hi mariahMC ,

Please try the following DAX for your Total Prev YTD measure and let me know if it achieves your desired result:

Test Total Prev YTD :=
VAR SelectedWeek = SELECTEDVALUE('Calendar Table'[Week Number])
VAR SelectedYear = SELECTEDVALUE('Calendar Table'[Year])

RETURN
CALCULATE(
    [Case Volume],
    FILTER(
        ALL('Calendar Table'),
        'Calendar Table'[Year] = SelectedYear - 1 &&
        'Calendar Table'[Week Number] <= SelectedWeek
    )
)

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Connect with me on LinkedIn

Check out my Blog

Going to the European Microsoft Fabric Community Conference? Check out my Session