Forum Discussion
Solved
help calculation
First of all, please excuse my lack of knowledge in making this inquiry. I have two tables, one for open tickets and another for closed tickets, and a table of dates (calculate dates). I have a dis...
rakelvillanueva Have a look at this, I created this specifically for the purpose you are describing:
Ticket backlog was a pain for me to.
Here's the DAX I used (Obviously, add your tables and columns):
Incident Backlog =
VAR CurrentDate = MAX('Date'[Date])
VAR ActiveTickets =
CALCULATE(DISTINCTCOUNT(Incidents[Number]),
ALL('Date'),
'Date'[Date]<=CurrentDate,
ISBLANK(Incidents[Resolved Date])
||Incidents[Resolved Date]>=CurrentDate)
Return
ActiveTickets
I hope this helps!
I have tried that solution several times and it has not worked for me.
Can you show me your version please?
If you've swapped out the tables/columns for yours there shouldn't be an issue. Do you have an active relationship between your date table and opened date?
