title: YYYMMDD Conversion to MM/DD/YYYY in Power QUery
body: <p>I have a column named <code>DimDateKey</code> in PowerQuery and it is formatted as YYYYMMDD i.e. 20150201 and I want to convert it to MM/DD/YY and I have had no luck finding the syntax for this.</p>
  
  <p>I have tried this which works in a regular excel sheet:</p>
  
  <pre><code>DATE(RIGHT([DimDateKey],4),MID([DimDateKey],4,2),LEFT([DimDateKey],2))
  </code></pre>
  
  <p>But I get </p>
  
  <blockquote>
    <p>Expression error: The Name DATE was not recognized. Is it Spelled
    Correctly?</p>
  </blockquote>