Cumulative of Sales when filtering by Month

Hi @Reckerman20,

I replaced your Dates table with the Extended date table you can find in the M code showcase.
Marked that as a Date table
Added a Month selector (disconnected) table and swapped that field in the slicer on the page
Added a measure to limit the number of months visible in that slicer, so it only shows the current selected and all months in the selected FY.
Enabled the interaction for all visuals, if they were previously disabled.
Created measures for Sales YTD and Sales PYTD that take this month selection into account.

.
Here’s your sample file.
eDNA - Mastering DAX Calculations.pbix (417.8 KB)

I hope this is helpful.