Watefall charts and formating data

[Zalexatwork]

Hello everyone,

I have a very simple data table that is made of 4 columns (with examples):
1                         2                                       3                                  4
Event                  Date of beginning            Date of ending          status
Event 1                01/01/2021                      04/02/2021               closed

Event 2                07/01/2021                      15/08/2021               open

Event 3                04/10/2021                      12/12/2021               cancelled

...

One or more events may be added every day/few days. 

My goal is to make a waterfall chart that would show how many are active every given month, and understand  the movements (+1 for newly opened and -1 for closed).
I am having trouble using the waterfall chart or finding the idea on how to format my data in order for it to be usable for the waterfall chart.
Any help would be greatly appreciated.
Regards,
A

[v-shex-msft · Accepted solution]

Hi @Zalexatwork,

It seems like a common multiple date fields analysis requirements, you can refer to the following link start date, end date parts if help:

Before You Post, Read This 

In addition, you can also try to create a bridge table to expand all the detail records in the date ranges and mapping with raw table records:
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,

Xiaoxin Sheng