Count all values after a certain value

h12

Hi all

I have a table like the below and essentially every month the number of 'dates' can change from 0 to 10 back to 5 etc. I essentially want to be able to count the number of dates that appear after 'Date Breach Occurred'. Dates will always follow this title, so hopefully theres a way we can do the count using this. The answer below would be 2 as there are 2 dates after 'Date Breach Occurred'.

Column Title =  Names

Cash Management

Cash Postings

Date Breach Occurred

2023-04-21

2023-09-12

ed_hayter

Lots of ways to approach this.

I opted for a multi row looking for the date breach occurred row as the row above and assigning 1 to the row below that and then for every other row copy the row above. So any row under date breached is 1 - a summarize then sums all the 1s

multi-rowcount.yxmd