Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I would like to identify a trend of the backlog of service tickets
The measure would count the number of tickets that arrived on or before the "date" and have a closed date on or after the date...
Example on last monday there were 20 open tickets, 15 were open prior to that day and 5 were opened on that day.
Wow, you don't even need a variation of Open Tickets, you need Open Tickets. It's even called Open Tickets!! 🙂
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
Tickets Open =
VAR tmpTickets = ADDCOLUMNS('service Ticket',"Effective Date",IF(ISBLANK([DateCompleted]),TODAY(),[DateCompleted]))
VAR tmpTable =
SELECTCOLUMNS(
FILTER(
GENERATE(
tmpTickets,
'Date'
),
[Date] >= [DateCreated] &&
[Date] <= [Effective Date]
),
"ID",'service Ticket'[TicketID],
"Date",[Date]
)
VAR tmpTable1 = GROUPBY(tmpTable,[ID],"Count",COUNTX(CURRENTGROUP(),[Date]))
RETURN COUNTROWS(tmpTable1)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
103 | |
64 | |
60 |