Power Query

Jenniffer Peterson 1 Reputation point

Could you please help on this issue below :)
I have data in power query connection that is combined in two columns:
Date Month
01.01.2021 January
23.01.2021 January
15.02.2021 February
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 :)

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
25,310 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 340.6K Reputation points MVP

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at

    --please don't forget to Accept as answer if the reply is helpful--