Merge 2 excel files

[Kanwals]

Hi All,

Just checking here if some one has video or could guide me how to merge latest created file and latest updated file dynamically in power query? 

[Attaluri]

Yes, Power Query can pick up all files available in source folder 

Based on time stamp of the file using power query or DAX we can create flag/columns to differentiate old and new files. 

Do let me know if you have further questions.

Regards,

Srini
js.attaluri@gmail.com

[Attaluri]

Hi,

There are multiple ways to do this. 

1. If both files are available in same folder. You can import both files mentioning source as folder path. 
2. If both files are different folder. You can import both files seperately and use Append queries feature in Power BI desktop. 

Please do let me know incase of any questions.

Regards,

Srini

js.attaluri@gmail.com

[Kanwals]

Hello Srini,

Would that work if we have multiple excel files and every week if I add new file and dynamically power query should pick new file as new created and file which was new a week before should be then latest updated? Please note that newly created excel file will be worked on daily basis after power query run.