Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • Anonymous , Change this like

     

    VAR DateFilter=
    FILTER( 'ContractData',
    AND( @Date >= BeginDate, @Date <= EndDate))

     

    or


    KEEPFILTERS(AND( @Date >= BeginDate, @Date <= EndDate))