How do i create a monthly sales report?

Hi parry2k thanks for your response!

This is the table I am working with, it pulls from a sharepoint folder that has new spreadsheets being uploaded to it every day. Instead of the bottom 2 rows having the same date with different sales values, I want it to combine both rows that have the date 2024-04 in it.

Again thanks for your reply.

parry2k 

That works well, but there is still multiple rows with the date 2024-04 in my  table, would there be a way for power bi to replace the existing row with new values?

parry2k 

In my Screenshot, the bottom two rows are from the same date, When my report updates a new row is created that includes the date 2024-04. My report updates daily so after 1 week I have multiple rows with the same date value. Is there a way I can replace the older rows with the newers rows that have the same date?

parry2k 

That is sort of how it works. It would be like 

file 1: date 2024-01-01 sales = 200

file 2: date 2024-01-01 sales = 300

But I want file 2 to replace file 1 when the dates match like that.

Thanks!