5 Replies Latest reply on Nov 13, 2018 5:59 PM by Dan Cory

    Displaying max period and prior period

    Kelly D'Arco

      I want my dashboard to automatically display both Max period in a data set and the prior period before the max (i.e. if 2018Q2 is the max period, I want to display 2018Q2 and 2018Q1). I was able to achieve part of my goal by using an LOD to display max period:


                [Period]= { FIXED : MAX([Period])}


      How can I modify this Calculation to add prior period? I think the solution is relatively simple I just can't seem to find it.