Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Sum({<[Date]=,[Date]={">=$(=(MonthStart(AddMonths(Max(Date),-1)))) <=$(=(MonthEnd(AddMonths(Max(Date),-1))))"}>}{$<[Date]=,Group={'3'}>}[Total])
can you try bypassing the date field
Sum({<[Date]=,[Date]={">=$(=(MonthStart(AddMonths(Max(Date),-1)))) <=$(=(MonthEnd(AddMonths(Max(Date),-1))))"}>}{$<[Date]=,Group={'3'}>}[Total])
can you try bypassing the date field
Thanks so much, Anat