Make dynamic filter to compare between selected period with the previous period

[ChristoNindyo]

Hello experts !

I have filter like below. This filter compare the latest period with previous period. I want made another filter with week (compare the selected week with the previous week), month, quarter, and year. How to do that ? 

All of the calculation is based on week in the report. 

Thanks before! 

[amitchandak · Accepted solution]

@ChristoNindyo , Try one of the two

//previous period
Same Date range last period =
var _diff = datediff(MIN('Date'[date]),max('Date'[date]),DAY)
var _p_st_date = MINX('Date',DATEADD('Date'[date],-1*_diff,Day))-1
var _p_end_date = MAXX('Date',DATEADD('Date'[date],-1*_diff,Day))-1
Return
CALCULATE(sum(Sales[Sales Amount]),all('Date'[date]),'Date'[date]>=_p_st_date && 'Date'[date]<= _p_end_date
)

Same Date range last period =
var _diff = datediff(MIN('Date'[date]),max('Date'[date]),DAY)
var _p_st_date = MINX('Date',DATEADD('Date'[date],-1*_diff,Day))-1
var _p_end_date = MAXX('Date',DATEADD('Date'[date],-1*_diff,Day))-1
Return
CALCULATE(sum(Sales[Sales Amount]),dateadd('Date'[date],-1*_diff,Day)

[ChristoNindyo]

@amitchandak Thank you !