Date Range in set analysis

[krissy_s]

I would like to show a list of quote reference numbers (i.e. a dimension) which fall within a specific date range. 

The set expression i have for the date range is:

[Expiry Date]={">=$(=monthstart(Today()))<=$(=monthend(addmonths(today(),2)))"}

But not sure how to write the complete set analysis. Can someone assist please?

Many thanks

[sunny_talwar]

What is wrong with the set analysis? Is it not giving you what you expected from it?

[Mauritz_SA]

Hi Kristen

Something like following should get you close:

AGGR(ONLY([Expiry Date]={">=$(=monthstart(Today()))<=$(=monthend(addmonths(today(),2)))"} [Quote Reference Number]),[Quote Reference Number])

@sunny_talwar , I think Kristen wants the list of reference numbers which satisfy his condition (i.e. set analysis in a dimension rather than a measure).

Hope it helps.

Regards,

Mauritz