Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello - I am looking to query the IPO data from here (https://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2018-01) I can pull individual dates, but I can't figure out how to iterate and take the data from multiple months and years. I've seen some examples, but can't seem to figure it out.
Thank you.
Solved! Go to Solution.
Hi @baltibeginner,
You can create a new table via Enter Data:
Then Invoke Custom Function, add a new column. Click on highlighted button can expand rows:
Best Regards,
Qiuyun Yu
Hi @baltibeginner,
Based on my test, you can refer to below steps:
1.Get data from web and use the advanced function, divide your URL into two paragraphs like the picture below.
2.Choose the Table 0 and click the edit.
3.Open the Advanced Editor and insert the "(para as text) as table =>" before the word "let" and use the "para" to replace the "2018-01" like the picture below.
4.Click "done" you can get a function window. When you enter the different date, you can get the result links with the data.
Best Regards,
Qiuyun Yu
Thank you @v-qiuyu-msft. This was very helpful. Instead of inputting each date. Am I able to pull a range of dates at once?
Hi @baltibeginner,
You can create a new table via Enter Data:
Then Invoke Custom Function, add a new column. Click on highlighted button can expand rows:
Best Regards,
Qiuyun Yu
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |