Forum Discussion
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.