title: DAX Today wasn't recognized
body: <p>In the Power BI I have a DAX function called <code>fnCreateCalendar</code> to create a Calendar dataset. I try to expand it a little bit to add some new atributes like <code>today</code> or calculate some month differences.</p>
  
  <p>Unfortunately the code below return the error 'An error occure in the "query.Expression.Error. The name 'TODAY' wasn't recognized. Make sure it's spelled correctly'. Please help - I am new to DAX.</p>
  
  <pre><code>(StartDate as date, EndDate as date)=&gt;
  
  let
      ...
  
      // the code below throws an error
      CurrentYearMonthNumber = Table.AddColumn(myTable, "CurrentYearMonthNumber",
          TODAY()
      )
  in
      CurrentYearMonthNumber
  </code></pre>