Forum Discussion
Using Date Slicer in Measure outside report context dates
I had several people test the link and it worked for about half . Fortunately one of the testers is better at googling questions than I am and found a solution in StackOverflow under the name "calculate-event-durations-to-only-part-within-sliced-period"
I just finished verifying the method provides the correct solution and was going to update this post - so excellent timing!
The key was to create a disconnected DATE table that is used in the slicer for the report. I can then calculated the difference between max(current contract date, slicer start date) and min(contract end date, slicer end date) without removing the data rows that have active contract after the slicer start date. I can provide more detail if anyone else has the issue or is unable to find the stack overflow solution.
thank you for looking!
nmp
I had several people test the link and it worked for about half . Fortunately one of the testers is better at googling questions than I am and found a solution in StackOverflow under the name "calculate-event-durations-to-only-part-within-sliced-period"
I just finished verifying the method provides the correct solution and was going to update this post - so excellent timing!
The key was to create a disconnected DATE table that is used in the slicer for the report. I can then calculated the difference between max(current contract date, slicer start date) and min(contract end date, slicer end date) without removing the data rows that have active contract after the slicer start date. I can provide more detail if anyone else has the issue or is unable to find the stack overflow solution.
thank you for looking!
nmp
Hi NMP,
Glad to hear that you have resolved the problem. Thanks for your sharing.
Regards,
Yuliana Gu