Share via

Power Query

Jenniffer Peterson 1 Reputation point
2022-02-13T13:30:29.773+00:00

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.
38,607 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-13T14:29:38.67+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.