All years and last month of current year expression

[Anonymous]

Hi!

Suppose I have data from 2012 to July 2013, I would want an expression to calculate sales from inception that's the entire 2012 and 2013 up to June only.

Thanks

[MayilVahanan · Accepted solution]

Hi

try like this

Sum({<Date={'>=$(=vStartDate)<=$(=vEndDate)'}>} Sales)

where vStartDate = Min(Date)

vEndDate = MonthEnd(AddMonths(Max(Date),-1))