Store historical data from a table that is updated daily

[Syndicate_Admin]

Good morning

I have PowerBI connected to the inbox of a mailbox, which allows me to have a table with all the emails that are there at that moment. This table is updated daily. I would like to be able to save a history of the unread emails that there are every day (one of the fields in the table tells me this information for each email).

I have created another table that includes a row with the date of the day and this count, but of course, every time the email table is updated this information is also updated, which means that I always have the data of the day but not save that history.

Can you think of any way to do it?

Thanks a lot!

[Syndicate_Admin]

Some time ago I had a similar problem and tried many things but I was not able to find the solution. I tried to save the information in a separate Excel but there was no way. Let's see if anyone knows how to do it.