title: Month name from date column
body: <p>I have a column  with date format, this kind of columns usually have a hierarchy with day, month and year to filter by but I'm using a direct query from my database and this doesn't appear. </p>
  
  <p>I've tried to split columns but when I try to split a column by name month this returns me an error because this kind of action is not compatible with a direct query.  </p>
  
  <p>Then I thought that one way to solve my problem as I can't do changes in columns it could be to make a Dax Function that extract month and year from my column</p>
  
  <p>This is the Column I'm talking about:
  <a href="https://i.stack.imgur.com/qu3W0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qu3W0.png" alt="Column Date "></a>
  This is the error when i try split columns by delimiter:
  <a href="https://i.stack.imgur.com/AYEup.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AYEup.png" alt="Error in DirectQuery"></a></p>
  
  <p>I've tried with MONTH function but this retuns me an error:
  <a href="https://i.stack.imgur.com/7PTIH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7PTIH.png" alt="Error"></a></p>