Forum Discussion
Helper IIIRemove current data from a table and update with YTD data
Hi,
I have a table with partner sales data from 2019 to MTD 2022 (till April); on a weekly basis sales data changes (for all 2022 data) since it is reported by the partner. How to remove only 2022 data and append again 2022 refreshed file.
Please help it is very urgent.
Mohan
2 Replies
- amitchandak
Super User
mohan_g_das1986 , There is DAX union approach, see if that use with filters
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ 
mohan_g_das1986This is incremental refresh, for me, it is totally different. I will have change across all the days of the current year so need to remove the entire 2022 and upload the new file on a weekly basis
