I'm trying to sum weeks 1+2 together when the display is by month.
The problem is that even when summing just weeks 1+2, I get the total for the whole month!
Not sure why it's happening, but it must be wrong what I'm doing.
Any help is appreciated.
[Measures].[Purchases First Half Month] AS