How to create a table with stored/archived measures for reporting?

[jenmar2023]

The data I have is refreshed/updated every Monday.  I would like to have a Table visual that captures the Total count of records that is loaded for all the weeks. 

Ex:  The dates reflected the data load date and the total number reflects the total # of records loaded

7/3/2023 = 1000

7/10/2023 = 1025

7/17/2023 = 1500

7/24/2023 = 1300

I currently have a measure table that captures the total number but the power slicer I have on the page is affecting this visual PLUS i need the table to almost 'hardcode' the total numbers from previous week.  How do I do this?  Thank you.

[amitchandak · Accepted solution]

@jenmar2023 , Is it a case of a snapshot?

if yes explore these solution

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

Other wise you can add week start/end date in table/date table and use that

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...

[jenmar2023]

Yes it is! Thank you!