Last 3 months in Set analysis

[chaitanyajami]

Hi all, I have 4 Years data in my data model, My req is :

Line chart: Dimensions as : Month Year, Quarter Year, Week Start, Year, Fiscal Year in cyclic group

Expression: Count({<[Month Year]={">=$(vmindate) <=$(vmaxdate)"}>}Distinct(ID)) but iam not getting correct results with the selections

of Year(2014,2015,2016,2017) and CalendarMonthName(Jan,Feb… to Dec)

vmindate=Num(Addmonths(Max([Month Year]),-2)

vmaxdate=Num(Addmonths(Max([Month Year]))

Chart Like: Selection Year=2016, Calndar MonthName= April then it should display feb ,march,april in that year , please suggest how to achieve this

[sunny_talwar]

Is your field called Month Year or month Year? Why are there no square brackets around your field Month Year? Would you be able to share a sample to look at your issue?

[chaitanyajami]

Hi,

its [Month Year], i wrote the spelling as it is for fields in expression. ok will share