This will give us current year current month and last year last month.
if month([Order Date])%12=0
or (month(today())=month([Order Date]) and year(today())=year([Order Date])) then [Sales] END
I need to calculate JAN2016-Dec2015, Feb2016-Dec2015,MARCH2016-DEC2015 like these.
I tried with you formula but it only displaying last month data,
But my requirement is LAST YEAR LAST MONTH -- Current Year( every month)