Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
86 | |
71 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |