Forum Discussion
Jira date table and Created vs closed table
- 1 year ago
Hi bzagata
If you want to show the tickets within the a date range based on either creation or resolution date, use USERELATIONSHIP to invoke an inactive relationship in a measure.
Please see the attached pbix.
If this isn't what you're looking form please provide a workable sample data (not an image because who wants to be manually typing data), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.
Hi bzagata
If you want to show the tickets within the a date range based on either creation or resolution date, use USERELATIONSHIP to invoke an inactive relationship in a measure.
Please see the attached pbix.
If this isn't what you're looking form please provide a workable sample data (not an image because who wants to be manually typing data), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.
Thank you for the help, it took me a few trys but I got it work using your example