Need advice

[Julies]

I have 3 group data. I need to get Feb 2020 total from group 3 and the filtered date was 1/3/2020, it returns the filtered date month total if used the expression below, where went wrong?

Group:3

Date	Total
1/2/20	5
2/2/20	4
3/2/20	5
. . .	. . .
1/3/20	3
2/3/20	3
3/3/20	6

Sum({<[Date]={">=$(=(MonthStart(AddMonths(Max(Date),-1)))) <=$(=(MonthEnd(AddMonths(Max(Date),-1))))"}>}{$<Group={'3'}>}[Total])

[anat · Accepted solution]

Sum({<[Date]=,[Date]={">=$(=(MonthStart(AddMonths(Max(Date),-1)))) <=$(=(MonthEnd(AddMonths(Max(Date),-1))))"}>}{$<[Date]=,Group={'3'}>}[Total])

can you try bypassing the date field

[Julies]

Thanks so much, Anat