4 Replies Latest reply on Aug 12, 2013 5:15 AM by Jonathan Drummey

    How to calculate date from month, year?

    . Gasikest

      Hi,

       

      I am rather new to Tableau, and calculations are not my strong side...

      I am trying to create a proper Date, but my data file has months as shown below. Is there anyone who would be so awesome to help me with the formula? Ideally, I would insert day 28 as well. So the date "April, 2011" should translate into correct date 04/28/2011.

       

      Thank you so much!!!

       

      Date
      April, 2011
      April, 2012
      April, 2013
      August, 2010
      August, 2011
      August, 2012
      December, 2010
      December, 2011
      December, 2012
      February, 2011
      February, 2012
      February, 2013
      January, 2011
      January, 2012
      January, 2013
      July, 2011
      July, 2012
      July, 2013
      June, 2011
      June, 2012
      June, 2013
      March, 2011
      March, 2012
      March, 2013
      May, 2011
      May, 2012
      May, 2013
      November, 2010
      November, 2011
      November, 2012
      October, 2010
      October, 2011
      October, 2012
      September, 2010
      September, 2011
      September, 2012