2 Replies Latest reply: Oct 30, 2017 2:40 AM by siddharth soam RSS

    Generating previous data from curent automated

    siddharth soam

      I am using the following expression


      if(H1='Previous Completed Quarter', Sum({<Quarters={$(=Concat(Distinct Quarters-1,','))} ,[Accounting Period]={$(=Concat(Distinct [Accounting Period]-3,','))}>}[Service Rev]),


      if(H1='Recent Completed Quarter',sum({$}[Service Rev]))



      where h1 is the header  and quarters are fetched from accounting period as follows.


      quarters accounting period

        1               1,2,3

        2               4,5,6

        3               7,8,9


      Problem is data is showing correctly for quarter>1 , but for quarter 1 no data is being shown.