Cumulative count in Table

Question

Hi All,&nbsp;I need to find the count of tickets by every row by date that how tickets are&nbsp; closed till the date in every row.&nbsp;Please check the below sample output i need Tickets till Current Closed date.&nbsp;

greg_deckler · Answer

Check out my Open Tickets Quick Measure:&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364

chotu27 · Answer

Greg_DecklerI need a totals by each row with closed date how many they are this one doesn't help me

greg_deckler · Answer

I'm not getting the logic for the calculation. Why do you have multiple rows of 4/4/2018 closed date with different numbers for the calculation you want?

chotu27 · Answer

Greg_Deckler&nbsp; If Suppose&nbsp;&nbsp;Ticket No 1 its closed date is&nbsp;4/6/2018 Open date is&nbsp;4/6/2018 then it is count as '1'Ticket No 2 its&nbsp;closed date&nbsp;is&nbsp;4/4/2018&nbsp;Open date&nbsp;is 3/28/2018 then it is count as '1'Ticket No 3 its&nbsp;closed date&nbsp;is&nbsp;4/14/2018&nbsp;Open date&nbsp;is 3/27/2018 then it is count as '3' because till the opendate of 4/14/2018 there are total alltogether 3 tickets closed&nbsp;&nbsp;&nbsp;

Forum Discussion

Cumulative count in Table

4 Replies

Related content

Cumulative Count DAX

Cumulative Total

Cumulative count of ticket

Cumulative Count by Date

Counting nulls