3 Replies Latest reply: Jan 26, 2016 4:57 PM by David Funk RSS

    Calculating Time Series Growth %

    David Funk

      I am trying to calculate QoQ growth % of sales through time and plot it in a manner similar to the chart below. I'm not sure if there is a way to do this through set analysis (all of my attempts have failed). I am able to calculate QoQ growth but only one period at a time



      (sum({$<[Time Period]={"12-2015"}>}[Sales])-sum({$<[Time Period]={"09-2015"}>}[Sales]))/(sum({$<[Time Period]={"09-2015"}>}[Sales]))


      .I've also tried  Not sure if it matters but each time period has ~2000 entries. Is there anyway to do this? Any help would be appreciated! Thanks in advance!