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'[SNAPSHO...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Change this like

 

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

 

or


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