6 Replies Latest reply on Jul 31, 2017 4:38 PM by Deepak Rai

    Comparing Current month data with previous year's month data

    Rupali jain

      Hi Guys,


      I'm creating a side to side bar graph of current month - year and I want it to compare with data of month of previous year. I created a calculated field for current month as :

      IIF(DATETRUNC('month',[Date Loaded]) = DATETRUNC('month',TODAY()),'true','false') and added in the Filter shelf.


      How do I add the filter for previous year data? For example, current month is July 2017, what is formula to find data for July 2016 such that I can this to the filter shelf and it helps to compare data.


      Thank you in advance.