Forum

Dynamic Parameterti...
 
Notifications
Clear all

Dynamic Parametertized Function in Power Query M

2 Posts
2 Users
0 Reactions
165 Views
(@raffrobb)
Posts: 38
Trusted Member
Topic starter
 

Hi Mynda: 

I want to  dynamically change the parameter for pulling data from the Wall Street Journal directly in the M Code advanced editor, and not from an Excel sheet.

I've tried just about everything, but unable.  I even used CoPilot and ChatGPT to no avail.

 I want to change the BA in
https://www.wsj.com/market-data/quotes/ BA/financials/annual/income-statement

to

https://www.wsj.com/market-data/quotes/ GD/financials/annual/income-statement

I tried
https://www.wsj.com/market-data/quotes/ "&Symbol&"/financials/annual/income-statement

with Symbol as a parameter but does not work or pass the new varable to the Parameter when I invoke a custom function with parameters.

How do I do this?

do you need my code or more specifics?

 

Thanks

Robb

 
Posted : 20/12/2023 4:00 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Robert,

Will be better if you can provide the code, hard to say why from your description.

 
Posted : 24/12/2023 5:04 am
Share: