How to create a measure that counts the cumulative number of bids over time, based on bid status

[Lamati]

Hello! I have a list of bids that go through various statuses over time. I would like to create a ribbon chart that shows me over time how many offers I have in each of the states, taking into account that when an offer changes state, the cumulative number of offers is modified. 

This is the list with my data: 

OfferID	Status_Change_Date	Status
1	08/01/2022	1. OfferSent
2	13/01/2022	1. OfferSent
3	18/01/2022	1. OfferSent
4	23/01/2022	1. OfferSent
5	28/01/2022	1. OfferSent
1	28/01/2022	2. Waiting Answer
6	02/02/2022	1. OfferSent
2	02/02/2022	2. Waiting Answer
3	07/02/2022	2. Waiting Answer
4	12/02/2022	2. Waiting Answer
5	17/02/2022	3.1. Closed
6	22/02/2022	3.1. Closed
1	27/02/2022	3.2. Pending_Payment
2	04/03/2022	3.2. Pending_Payment
3	09/03/2022	3.2. Pending_Payment
4	14/03/2022	3.2. Pending_Payment
1	14/03/2022	4.1. Payment Received
2	19/03/2022	4.1. Payment Received
4	29/03/2022	4.2. Cancelled

With this data, I have created a measure with which I try to count cumulatively the offers according to the status, but it does not take into account the change of status of the offer:

State_Change_Count =

    CALCULATE(

        COUNTROWS('Original Data') ,

        FILTER(ALLSELECTED('Original Data'[Status_Change_Date]),

            'Original Data'[Status_Change_Date] <= MAX('Original Data'[Status_Change_Date])

    ))

If I plot this measurement on a ribbon chart, I get the following result:

How do I have to modify my measurement in order to obtain a result like the following?

I would be grateful for any help, because I am stuck and I don't know how to continue in order to get what I am looking for.

Thank you in advance

[amitchandak]

@Lamati , You should always use a separate date table in such cases joined with date of your table. Period from date table should be used in visual, measure and slicer

State_Change_Count =
CALCULATE(
COUNTROWS('Original Data') ,
FILTER(ALL('Date'[Date]),
'Date'[Date] <= MAX('Date'[Date])
))

Running Total/ Cumulative:
https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42

You can use Window function too

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f

[Lamati]

Thank you for your reply!!;

I have made the modifications you suggested, but I still don't get a cumulative count that changes depending on whether or not an offer changes status.

With your formula I get the cumulative count over time, but of the total number of bids, without the effect of the change of status.

[Lamati]

Sankey Chart