Monthly File Integration

[JMSNYC]

Hi.

I have the current issue for which I cannot solve:

I need to

1. keep the latest files of each month (but the current) , and
2. append these to the lastest file of the month.

Sounds trivial, but I cannot make it happen.

Thank you for your guidance

JM

[mahoneypat]

This is doable but not clear on your request.  Can you provide a sample table of filenames and created dates, and identify the ones you'd like to keep (so you can combine them)?

Regards,

Pat

[amitchandak]

@JMSNYC , these two blogs talk about DAX append, see if that can help

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/

[JMSNYC]

Thank you for your quick answer, but I need this to be completed in Power Query