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.