(I'm sorry if my English is bad, I'm French and I'm not an expert in this language)
I have a problem with a job given by a colleague and I have little knowledge of Power Query (and VBA is worse).
I explain: I have collected data from a URL of a site that compiles the statistics of visits on the homepage of our site. This URL contains filters generated by the statistics site. Among these filters, there is a date. The statistics are those of the month of the filtered date. I need to set up a drop-down list in which each option will change the date directly in the retrieved URL, and this on the same starting sheet.
Example: if I choose "November 2018" in the drop-down list, the date in the URL will become "01-11-2018", for "December 2018", it will become "01-12-2018", etc. after.
I have already looked everywhere to add parameters to Power Query and to dynamically modify the URL with VBA, but I can not find a precise answer to my problem.