Forum Discussion
How to refresh excel data and remove previous data automatically
I have to update a reporting template based on an excel sheet. How could I update excel sheets automatically and remove previous data? I can upend data by using Power Query refresh. I do not want tha...
Hi,
You can handle this easily in Power Query by filtering your date column to include only the current week, for example using:
Date.IsInCurrentWeek([Date])
That way, old data clears automatically on refresh. I’ve implemented a similar setup for my own reporting dashboard on my https://www.crscalculate.com and it works smoothly.
— James Carter