Incorrect Syntax When Running a SQL Statement

[Anonymous]

Hello,

I am currently pulling data from a SQL Server into Power Bi.  While this works great, it is pulling data all the way back to 1996, which makes it take an increasing long time to refresh. I would like to only get work orders with a lagging 365 creation date. To do this, I was trying to add a filter via the "SQL Statement" advanced option.  

Below is what I am entering:

evaluate

(

   filter

   (

     'workorder',

     'workorder'[datestart] >= Today() -365

   )

)

This is the error:

DataSource.Error: Microsoft SQL: Incorrect syntax near 'filter'.

Details:

    DataSourceKind=SQL

    DataSourcePath=sql1028-fm1-in.amr.corp.intel.com,3180;tracssprod

    Message=Incorrect syntax near 'filter'.

    Number=102

    Class=15

Any help would be greatly appreciated as I am something of a novice when it comes to DAX.

Turner