1 Reply Latest reply on Jul 3, 2018 10:38 AM by Hamza Alsalman

    month to date based on first available data

    Hamza Alsalman

      I have data that loads into tableau. It is called production dates. Sometimes data gets loaded in on the first of the month, sometimes the second, or even the third of the month depending on the weekday available data. What I need to do is do a month to date calculation which essentially shows today's balance amount - the balance amount on the first day of the month whether it was the third, second or first.

      Ex:

      Production date               balance

      June 1st                        15

       

      today(June 20)                         20

       

      MTD calculated field= 5

       

      or some months have it set up like

       

      October 3                 10

      October 20(today)    9

       

      MTD field=   -1