Forum Discussion
paginated report- Query correction
Hi All,
I am using below query to create a report a paginated report.
DEFINE
VAR BeginDate = DATEVALUE( 'ContractData'[SNAPSHOT_BEGIN_DATE])
VAR EndDate = DATEVALUE( 'ContractData'[SNAPSHOT_END_DATE])
VAR DateFilter=
FILTER(
KEEPFILTERS(VALUES(@Date)),
AND( @Date >= BeginDate, @Date <= EndDate))
EVALUATE SUMMARIZECOLUMNS('ContractData'[ACCOUNT], 'ContractData'[Due Date], RSCustomDaxFilter(@ContractDataCONAME,EqualToCondition,[ContractData].[CO_NAME],String),
DateFilter)
When i validate above query getting "no parameter match for multivalue placeholder"
Could you please help to resolve this issue.
thank you in advance
1 Reply
- amitchandakSuper User
Anonymous , Change this like
VAR DateFilter=
FILTER( 'ContractData',
AND( @Date >= BeginDate, @Date <= EndDate))or
KEEPFILTERS(AND( @Date >= BeginDate, @Date <= EndDate))