Re: Monthly File Integration

JMSNYC · ‎01-08-2021

Hi.

I have the current issue for which I cannot solve:

I need to

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

Sounds trivial, but I cannot make it happen.

Thank you for your guidance

JM

mahoneypat · ‎01-10-2021

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

amitchandak · ‎01-08-2021

@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/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube