Previous Month Visual Using Week End Date

[Anonymous]

I have a report that is filtered by the Week_End_Date, one of the visuals looks at the previous month data, however, when I select the slicer to view a Week_End_Date such as 6/5/2021 (when the previous month ended in the currently selected week) the filtering won't show the new previous month until the Week_End_Date of 6/12/2021 is selected. I hope this made sense. 

While the numbers are right, I want the filters to show the real previous month in these instances. 

The Calculation i am using is show below... 

% Below 30 CALC =

CALCULATE (

values('% BELOW 30'[% Below 30]),

PREVIOUSMONTH('CALENDAR'[REPORT_DATE]))

What the data shows 

What the data should show for 6/5/2021

Calendar Table

[amitchandak · Accepted solution]

@Anonymous , previous month consider first date in context. Try datesmtd with endofmonth

% Below 30 CALC =
var _max = maxx(allselected(),'CALENDAR'[REPORT_DATE])
CALCULATE (
values('% BELOW 30'[% Below 30]),
DATESMTD(ENDOFMONTH('CALENDAR'[Date])))

[Anonymous]

This worked! Thank you so much!