Urgent Help Required Please on Power Query

[AsimJaved]

I need to bring in data from following website for last 4 years. The problem is that its loaded with a datepicker which does not appear in web address, which i could use with parameters table. 

Site is: https://www.nccpl.com.pk/en/market-information/fipi-lipi/fipi-sector-wise

I want to wite one M code which i can automate through parameters and combine all data in Power BI. Please help to resolve this issue.

Thanks in advance.

AJ

[v-shex-msft · Accepted solution]

HI @AsimJaved,

I'd like to suggest you take a look at following link which told about dynamic date filter based Datetime.LocalNow or similar M query functions:

Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month

Regards,

Xiaoxin Sheng