FilterPane with WTD,MTD,YTD filters

[AdrianS1]

Hi guys, i have a problem. I need to have a three filter panes with WTD,MTD,YTD. I have one table with OrderDate and Sales.

I used function for YTD =(YearToDate(ORDER_DATE)) and it works. How should i switch this function to MTD and WTD. Could someone help me?

[BrunPierre]

MTD =Aggr(Only({<DateField={">=$(=MonthStart(Max(DateField)))<=$(=AddMonths(Max(DateField)))"}>} DateField), DateField)


WTD = Aggr(Only({<DateField={">=$(=WeekStart(Max(DateField)))<=$(=Date(Max(DateField) ))"}>} DateField), DateField)