how to calculate count of date with a filter

[TomBrown]

hello evrybody 

i have a tiketing system and im trying to calculate the "backlog" in the system/

i have a opend column ( date time ) and a resolved column (date time) 

im looking to calculate the numer of cases that where open on a any date - the number of cases that was resolved before midnight that day. 

any ideas ??  

[Mariusz · Accepted solution]

Hi @TomBrown 

Duplicate opened column and late format this column to date only 

opened date = table[opend column] 

Add another column 

resolved same day = 
IF( 
    INT( 'Table'[date] ) = INT( 'Table'[resolved column] ),
    "Yes",
    "No"
)

Add measure 

Measure = COUNTROWS( 'Table' )

Add all to a table visual

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

Refer, if this can help : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Greg_Deckler]

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364