4 Replies Latest reply: May 17, 2018 8:58 AM by Michael Anywar RSS

    Help with date data selection.

    Michael Anywar

      I have these as my expressions:

       

      Sum({<Year = {">=$(=min((EndYear)-1))<=$(=max((EndYear)-1))"}>}[Population, total]

       

      Sum({<Year = {">=$(=min(EndYear))<=$(=max(EndYear))"}>}[Population, total]


      The whole point is I would like to achieve or fill the pivot with population values of the end year.

       

      I tried using the same expression to create  variables but still its not working.

       

      In the end I need achieve  (End Year Population - Previous Year Population)/Previous year )*100

       

      Any help very much appreciated.

       

      Michael


      Screen Shot 2018-05-17 at 15.33.46.png