Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
LokambaTH
Helper I
Helper I

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.

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.