Set Analysis doesn't roll the figures

[RichardLee]

I'm trying to use Set Analysis to create a rolling 12 months from a selected Date

sum({<[Master Date]={"$(=MonthEnd(Addmonths(Max([Master Date]),-1)))"}, [Data Type]={'Actual'}>} Value)

I dont seem to be able to get this to work.

all my dates are the End of the month and they need to only sum the 'Actual' items. But when I select a date the value is always Zero.

I'm beginning to this isn't possible or I am missing something.

[vikasmahajan]

Can you try to add Date#() 

sum({<[Master Date]={"$(=MonthEnd(Addmonths(Max(Date#( [Master Date],' MMM YYYY')),-1)))"}, [Data Type]={'Actual'}>} Value)

HTW

Vikas

[RichardLee · Accepted solution]

I figured it out with a little out of the box thinking.

I added a seperate data feed not linked to the main data to select a date with out filtering the main data.

SUM({<[NL.Month Name] = {'$(=AddMonths(Max([Date.Month Name]),-1))'}>}TransactionValue)