Forum Discussion
Solved
Cumulative difference between count of two dates
I have something that I haven't been able to solve trying to get information from a ticketing system. I have a table with two date fields, opendate and close date. I have made two measures to calcul...
You may refer to the following posts.
May be create a conditional column for closed Tickets and Open ticket based on Closed Date.
So If closed date is not null them Ticket is closed and display 1 and name this column as ClosedTicketCounts
Similar way If Closed Date is Null them display 1 and Rename this OpenTicketCounts.