Help With Event In Progress Visualization

Howdy!

Thank you for the apology.  🙂

I found this article that might interest you.  But I took a simpler approach to the problem.  Here's the code:

Events Open in Period = 
    VAR EventsCreated =
        CALCULATETABLE(
            VALUES(ft_records[Record_ID]),
            FILTER(
                ALL(ft_records),
                ft_records[Start Date] <= MAX(Date_table[Date])
            )
        )
    VAR EventsPreviouslyClosed =
        CALCULATETABLE(
            VALUES(ft_records[Record_ID]),
            FILTER(
                ALL(ft_records),
                ft_records[Finish Date] < MIN(Date_table[Date])
            )
        )
    RETURN

    COUNTROWS(
        EXCEPT(
            EventsCreated,
            EventsPreviouslyClosed
        )
    )

What we're doing here is creating a couple of table variables.  The first one is all events opened on or before the last date in a month.  The second is all events closed prior to the month in question.  I'm working with the assumption that an event will be open - even if only for an instant - if it happened to be closed on the same day.  The EXCEPT() function returns rows from one table that are not found in the other, and then we just count the rows.  Here's what the result looks like.

I spot checked this in Excel by manually counting records for June and July and it appears accurate.  But you should probably check a little more just to be sure.

You can download the PBIX here.