how to accumulate data

[luis_pflucker]

Hi, I have a table where its information needs to be replaced every days , issue here is the next day (for instance tomorrow) I will lose the quantity of rows of the day before, is there any way to keep recording this number of rows and within the date stamped in order to have at end of month the qty of records day by day?.

For instance: my table yesterday (D -1) had 10 records, today (Day 0) 15 records, tomorrow (Day +1)  18 recods, Day+2 = 25 records, and so on, REMEMBER table is replaced every day, then what I would need is to keep recording the counting in other table: Day -1: 10, Day 0: 15, Day +1:18, DAy +2: 25, etc. Is possible to do that?I would appreciatte any suggestion.   

[AllisonKennedy]

Power BI is a data visualization tool, not database. You could look at using Power Automate to save the information you need in SharePoint or Excel and reference that from Power BI.