2 Replies Latest reply on Oct 15, 2018 2:28 AM by Patrick Weber

    stock value at the beginning and at the end for each month

    Patrick Weber

      Hi friends of Tableau.

       

      My issue: I have data of a warehouse (see example workbook) in this case for just one product.

      On the date column you'll see the date when the stock value has changed the last time.

       

      Now I need to know the stock value at the beginning and at the end for each month.

       

      In this example there would be  135 on Sept 01 because the value has changed the last time on Aug 29.

      At the end of Sept (Sept 30) there would be still 89.

       

      Which kind of calculation/function could I use?

       

      Thanks in advantage for any hint or tip.