Forum Discussion

bzagata's avatar
bzagata
Frequent Visitor
1 year ago
Solved

Jira date table and Created vs closed table

I am making a dashboard for Jira. I have multiple reports on one page and want to set it up with a slicer to filter by relative date. Most of the tables use the created column in the jiraissue table,...
  • danextian's avatar
    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.