Forum Discussion
ERIC_A
Helper II
Helper IITicket Open and Closed DistinctCount
Hello, I have the following Table Ticket Open Date Closed Date A 1/1/2023 1/1/2023 B 1/1/2023 1/1/2023 C 2/1/2023 2/1/2023 D 2/4/2023 2/1/2023 E 12/31/2022 1/1/...
Hi,
PBI file attached.
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
PBI file attached.
Hope this helps.
ERIC_AHelper II
Helper IIhi Ashish thank you for your PBIX. your approach is interesting and is similar of what I did yesterday.
here is how I solved it .
I created a union table with the tickets and open date + tickets and closed date.
Open+Closed = union(
SELECTCOLUMNS('Data',"Ticket",'Data'[Incident],"Date",'Data'[Tkt Crtn Date]),
SELECTCOLUMNS('Data',"Ticket",'Data'[Incident],"Date",'Data'[SolutionAppliedDate]))
and then I used this to obtain the distinct counts of tickets for a specific date.
thank you for your response!
- Ashish_Mathur
You are welcome.