Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
3 | |
3 | |
3 |