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.



      Screen Shot 2018-05-17 at 15.33.46.png