[Help Plsss!] Daily Report Export into Compiling excel file

I have a dashboard I am creating that contains the daily cash amounts received from clients. The report I am working with is displaying the total cash amount for the current day.

My goal is to somehow export the report daily and add that to an excel file. Basically, taking a snapshot of each days cash amount, exporting the report, compiling it to an existing excel table. This way I have my own "database" that contains the exact cash amounts on those particular days. (Right now these numbers can change at any point, but I want to see the true value on each particular day).

For example, pretend the image below in white is a table result on my Power BI Dashboard.

Lets say the below table is what I currently have in the Excel file for yesterday.

I want to be able to export the first table from my BI Dashboard and add it to the above excel table to get the below compilation of my day to day cash reports.