title: How to convert this Text field into a DATE field using DAX formulas?
body: <p>I am using Excel 2013 and I have a Powerpivot table which pulls data using an SQL query. One of the columns of the output (called MTH) is in TEXT format and shows dates as follows: 2014-09-01 00:00:00.000</p>
  
  <p>I need a new calculated column that would give me the following result, for the example above: Sep-2014 or may be, September 2014</p>
  
  <p>Which DAX formula do I need?</p>