1 Reply Latest reply on Mar 8, 2017 1:50 PM by Jeff Strauss

    Tableau Functions

    magdalena.bielaski.0

      Hi,

       

      I have weeks: 1,2,3,4 and I have ending inventory.

       

      week:          1      2       3       4

      end inv:       10  15      16     17

       

      How would I create a new variable: beginning inventory which is equal to the ending inventory from the previous week.

       

      For example my end inventory at week 2 was 15 so my beginning inventory at week 3 should equal 15. What formula do I use in order to create beginning inventory measure.

       

      Thank you,