Archiving data to create trends

Hi all,

Within our organization we want to create weekly reports in which we show the current state of system status but also archived the data to create trends.

For example the dataset looks like the following on 01-07-2022 (week A):

We want to know how many orders have a system status of Approved at this moment.

In this case it is 2.

A week later (week B) the dataset has changed to the following (08-07-2022):

We see that more orders have been added to the dataset and that the system status has changed for several orders.

We still want to know how many orders have a system status of Approved at this moment. 

Which in this case 4. 

As mentioned earlier: within our organization we want to create weekly reports in which we show the current state of system status but also archived the data to create trends.

So, how many orders had the system status "Approved" in week A and have the system status "Approved" in week B.

The current data has overwritten the old data, because the status of particular orders have been changed. 

Is it possible in Power BI to create a table like the following:

Which creates every week a new row with the current value of the amount of orders that have the status "Approved". 

Thus Power BI looks at the current state, calculates the amount, and puts it in a new table under row A.

Same goes for week B, look at the current state and put the value in a new row B.

And so on. 

So we have historical data and current data (live data).

 We receive our data through a gateway (so, it comes from a direct query).

Thank you in advance.