Forum Discussion
Submit OR Closed Filter
Hi All,
I'm trying to build a KPI report that includes both tickets opened or closed within a set date span.
Each ticket has a submit date column and closed date column.
Currently, the date slicer I have is tied to a date table which is related to the submit date and resolved date where the resolved date is an inactive relationship. The totals do not include tickets submit before the date span in the slicer where the resolved date does.
This is what I need:
I've searched everywhere for a solution with no luck. Is this possible?
Thanks
1 Reply
- v-danhe-msftMicrosoft Employee
Hi Anonymous ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He