Refreshing data with new totals

[CharnanK]

I have a dashboard with fortnight refreshing.  The data is an XS Annual Leave spreadsheet so a lot of rows will be duplicated with and increase in the $ value.  How do I update the totals to reflect the new $$'s but keeping the old data for comparison? 

But when I refresh for the next FN - it doubles the total due to duplicates.  If I delete the rows that are duplicated, it deletes the previous FN record.  
I'm so confused. 

[FreemanZ]

hi @CharnanK ,

try to introduce a datestamp column with the value of every fresh date. 

[CharnanK]

@FreemanZ can you give me an example? Not used a DateStamp column before

[FreemanZ]

hi @CharnanK ,

1) Ask your datasource to add that column, or

2) Save a offline copy on each data refresh, add a date column manually, and merge all offline copies in Power Query.