calculate open tickets by date

[kafil10]

hi,

I have a db that contains tickets a ticket is created in a date and closed in an other,

the ticket is open if he dont have a date closed or he is between the two dates

the question is how in per exemple in 10/07/2016 i can know the exactly number

of tickets with DAX please ??

[v-chuncz-msft · Accepted solution]

@kafil10,

Here is a similar post for your reference.

http://community.powerbi.com/t5/Desktop/Trend-from-History-Table/m-p/200304#M88115

[Greg_Deckler · Accepted solution]

Given a table of Dates, how about a calculated column like this?

OpenTickets = CALCULATE(COUNTROWS(Tickets),FILTER(Tickets,(Tickets[create_ticket]<=[Dates] && ISBLANK(Tickets[close_ticket_date]) || (Tickets[create_ticket]<=[Dates] && Tickets[close_ticket_date]>=[Dates]))))