Hello all,
Yet another set analysis question. I have the below expression that I want to take into account any current selections (expect month) and the BM13 bookmark, but I want it to include the specified months only. This works as long as I don't have any month selections made. If I make a month selection that doesn't include the months specified in the modifier (current quarter), the result is wrong. I want the months to always be the ones defined in the modifier regardless of month selections. All other selections and the bookmark should apply though. Where am I going wrong?
=Sum({$*BM13 <Month={'>=$(=Num(Month(QuarterStart(today()))))<=$(=Num(Month(QuarterEnd(today()))))'}>}[Sales Amount])
Any help is appreciated.