Forum Discussion
PowerBI Jira Connector - Issues Per Assignee over Time
Hi BSands ,
As we haven’t heard back from you, we will go ahead and close this ticket for now.
If you need any further assistance, please don’t hesitate to raise a new ticket, we’re always happy to help.
If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Our sincere apologies if there was any inconvenience caused.
Regards,
B Manikanteswara Reddy
Hi BSands ,
Thank you for reaching out to Microsoft Farbric Community Forum.
Akash_Varuna Thank you for your quick inputs.
BSands , As Akash_Varuna mentioned, the first step is to create a Calendar table, which allows analyzing ticket assignments on a day-by-day basis as below:
Calendar =
CALENDAR(
MIN('History_Status'[History New Value Start]),
MAX('History_Status'[History New Value Start])
)
Then create the below DAX Measure to Count Assigned Tickets (e.g., for "bob"):
Tickets Assigned to Bob =
VAR SelectedDate = SELECTEDVALUE('Calendar'[Date])
RETURN
CALCULATE(
COUNTROWS(FILTER('History_Status',
'History_Status'[History Field] = "assignee" &&
'History_Status'[History New Value] = "bob" &&
'History_Status'[History New Value Start] <= SelectedDate &&
(
ISBLANK('History_Status'[History New Value End]) ||
'History_Status'[History New Value End] >= SelectedDate
) &&
NOT (
'History_Status'[Key] IN
CALCULATETABLE(
VALUES('History_Status'[Key]),
'History_Status'[History Field] = "status",
'History_Status'[History New Value] = "done",
'History_Status'[History New Value Start] <= SelectedDate
)
)
))
)
|
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos " – I’d truly appreciate it! |
Regards,
B Manikanteswara Reddy
Hello,
Thank you, I have a date table with date/time format, A true/false column for IsBusinessDay and BusinessDayIndex. I tried the measure you gave and it comes up blank when I try to create a visual with it. The date/time for historynewvaluestart has an exact time, where my date table all has 12:00:00am so I created another column in the history_status table converting them all to 12:00:00am, but still nothing comes up.
