i have a slicer for Month/year, when i filter this slicer i am expecting my data to pull for the appropriate month selected. Some of my data are measures with a date calculation (the date table is unrelated). The issue I am running into, is that my data is only pulling YTD, so when i filter for June the data looks good but when i filter for May, it still keeps my June data. below is my measure, any ideas what i am doing wrong? I am assuming it has to do with a relationship of the filter?
Stage 4a Actual test =
var maxmonth= LASTDATE('Consolidated Talent Snapshot (2)'[Data as of])