need variable dates in dax query for power automate

I'm trying to make the dax dynamic related to dates, I have a filter for  all pages which shows data for previous month only and when I'm using the dax using performance analyzer then dax is static where in the date can't be changed

but I want the date to refer previous month instead of hard coding the dates in the dax

Is there any way to make the red in dynamic so that data can be retrieved based on month 

// DAX Query
DEFINE

VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('Calendar'[Date])),
AND('Calendar'[Date] >= DATE(2022, 9, 1), 'Calendar'[Date] < DATE(2022, 10, 1))
)

VAR __DS0Core =
CALCULATETABLE(
SUMMARIZE(
'Column names
),
KEEPFILTERS(__DS0FilterTable)
)

VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
column name ,
1,
'column name,
1
)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
'column1,
'column2