Could you please help on this issue below :)
I have data in power query connection that is combined in two columns:
During the month I have to update the power query with New files from folder. Each file has Today date and Month. For example if the month February exists in the New file then the query has to automatically replace the existing dates only for February with the ones from the New file with Today's date. At the same time the dates for January should remain in the query.
My idea is every time when a New file is added in the folder, the data in power query to do the replacement of dates as described above.
Thank you very much in advance :)