Need help in Query preparation- paginated report..

[LokambaTH]

Hi All,

I am using below query to create a paginated report. 

When i run the query getting syntax error. Could you please provide some solution.

Thank you.

[amitchandak]

@LokambaTH , Try like

Define
Var BeignDate=Cast('ContractData'[SNAPSHOT_BEGIN_DATE] as date)
Var EndDate= Cast('ContractData'[SNAPSHOT_END_DATE] as Date)

EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT],

FILTER(VALUES('ContractData'[OVER 90]),'ContractData'[OVER 90]="YES" && ContractData[CO_NAME] = @ContractDataCONAME),

FILTER('ContractData', @Date>=BeignDate && @Date<=EndDate))

[amitchandak]

@LokambaTH , Please share the query in text format with the error. Difficult to tell with image

[LokambaTH]

@amitchandak ,

Please see the below query used in report along with error measage. (removed some columns here) 

Define
Var BeignDate=Cast('ContractData'[SNAPSHOT_BEGIN_DATE] as date)
Var EndDate= Cast('ContractData'[SNAPSHOT_END_DATE] as Date)

EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT],

FILTER(VALUES('ContractData'[OVER 90]),'ContractData'[OVER 90]="YES"),
RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String),

FILTER('ContractData', @Date>=BeignDate && @Date<=EndDate))

[LokambaTH]

@amitchandak  thank you so much for soultion. but the problem is in date conversion and last filter syntax. if i removed last filter line, query works fine. 

[amitchandak]

@LokambaTH , like

FILTER('ContractData', datevalue( @Date) >=BeignDate && datevalue( @Date)  <=EndDate))

else we need create date based on format

[LokambaTH]

@amitchandak   used above syntax , now i am getting below issue: