Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help in parameter setup - Paginated report.

Hi All,

 

Below query i am using to create paginated report:

 

EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT], 'ContractData'[Due Date], 'ContractData'[SNAPSHOT_BEGIN_DATE], 'ContractData'[SNAPSHOT_END_DATE], 'ContractData'[SKIP], 'ContractData'[60 NON-REPO], 'ContractData'[PICKUP PEND], RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String))

 

In  main dataset, have two date fields(SNAPSHOT_BEGIN_DATE and SNAPSHOT_END_DATE).

Problem statement: when user selected any single date below query need to used to fileter the data.

Selected Date>=SNAPSHOT_BEGIN_DATE and Selected Date <= SNAPSHOT_END_DATE.

 

Could you please provide some inputs to create custom date parameter and apply custom date parameter value to filter the data based on above logic.

 

Thank you in advance.

No Replies