I have created two measures:
Total Members Current = CALCULATE([Total Members],DATEADD(DIM_DATE_ACCRUALS_All[DateDescription],-0,month))
Total Members Previous 1 = CALCULATE([Total Members],DATEADD(DIM_DATE_ACCRUALS_All[DateDescription],-1,month))
Issue 1: When I select these measures in a report, they still require a visual level filter to determine the period. Fair enough...so I have added a time calculated column and selected "current" or "previous month", it works (but I can also just select [Total Members] with the time calculated column and get the same result)
Issue 2: More important than issue 1: I want a field on my report that reflects the difference between this month and last month. I have created a measure:
Member Shift = [Total Members Current] - [Total Members Previous 1]
When I pull this into my report, it shows 0 (the answer should be 477)
If I add the time calculated column and select "current" it reflects ALL members in the current month, if I select "previous month" it reflects ALL members in the previous month - I need the variance or difference between these months....
