How to count number of rows in dataset - per current month

[Svgevoodoo]

How best is it to count the rows (with a certain status) in a dataset on a monthly basis, and to lock that value into a table.
i.e. It is Currently July so the measure will fluctuate daily until the 1st Aug - where it will lock in that there were 200 rows (with the certain status) against July 2022.  And then start counting again from Aug - until Sept.

Month / Yr	Hopper Size
Jan 2022	no data avaialble, as the measure wasn't run in Feb
Feb 2022	no data avaialble, as the measure wasn't run in Mar
Mar 2022	no data avaialble, as the measure wasn't run in Apr
Apr 2022	no data avaialble, as the measure wasn't run in May
May 2022	no data avaialble, as the measure wasn't run in June
June 2022	no data avaialble, as the measure wasn't run on 1st July
July 2022	200 - the measure runs until 1st Aug, where it then locks in the last calculated value to the table
Aug 2022	tbc

Current Measure I have running - which counts the as-current hopper size

Hopper Size = Calcualte(Distinctcount(#),Fitler(OR(status="1",status="2")))

[Anonymous]

Hi @Svgevoodoo ,

//How best is it to count the rows (with a certain status) in a dataset on a monthly basis, and to lock that value into a table.

Currently, Power BI does not support saving snapshots of data or similar features. This means that after refreshing the data the data may change and they will not be locked in the table. You can refer to the answer in this thread and consider exporting a snapshot of the data at the end of each month.

Solved: Data Snapshots - Microsoft Power BI Community

For such kind of needs, I would suggest you submit an idea in Power BI Ideas: Microsoft Idea

It’s a place where the product group collects suggestions from users to improve the features of this product. Thanks in advance!

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data