Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Query correction in paginated report

Hi All,

 

1. Below query i am using to create paginated report:

EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT], 'ContractData'[Months Due], 'ContractData'[EPO Discount], 'ContractData'[SNAPSHOT_END_DATE],
Filter('ContractData','ContractData'[OVER 90]="YES"),
Filter('ContractData',Cast('ContractData'[SNAPSHOT_BEGIN_DATE] as Date)>="@Date"),

RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String))

 

2. Created Date parameter and added date parameter in main dataset also.


3. When i run the report, getting below issue.

 

 

Could you please tell me is any changes in query or any inputs.

 

Thank you in advance.

No Replies