Incorrect Syntax When Running a SQL Statement

Anonymous — Wed, 25 Sep 2019 21:29:51 GMT

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

topic Incorrect Syntax When Running a SQL Statement in DAX Commands and Tips

Incorrect Syntax When Running a SQL Statement