need last 18 months of data

[raj777karthik]

I have creation date column in which i need to see past 18 months of data from max created date ,If it is created in last 18 months from max creation date then it will be yes else no.Need to create calculate column

[amitchandak · Accepted solution]

@raj777karthik , Based on what I got. In your, date table joined with the table have this column ( or in table)

new column flag=

var _max  = max(Table[Date])

var _min = date(year(_max), month(_max)-18, day(_max))

return

if([Date]>= _min && [Date] <= _max, "Last 18", "Other')

or a new measure

var _max  = max(Table[Date])

var _min = date(year(_max), month(_max)-18, day(_max))

return

calculate(sum(Table[Value]), filter(Table, Table[date] >=Min && Table[Date] <=_max))