2 Replies Latest reply on Dec 26, 2013 8:40 AM by Alexandra Ciccariello

    Tableau formula to show data through last full month (i.e. Jan-Nov 2013)

    Alexandra Ciccariello

      I am trying to create a formula that shows data through the current full month.Right now my forumla is calculating YTD information. I want it to capture data through the latest full month. Since today is Dec 26th, and December is not fully completed, I only want to show data from January through November 2013. See my formula below... Is it possible to amend this so it only looks at the latest full month? Ultimately I want this calculation to be smart enough that I don't have to change it every month.

       

      IF DATEDIFF('year', [TRADE_MONTH], TODAY()) = 0

      THEN [USD_COMMISSION]

      END

       

      Any advice would be greatly appreciated!

       

      Thanks so much


      Ali