Remove current data from a table and update with YTD data

[mohan_g_das1986]

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 

[mohan_g_das1986]

This 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

[amitchandak]

@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-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/