Forum Discussion
Dynamic from date and to date in web source query
Hi All, In the below code, I need the bold ones to read data based on user selection of start and end date. Kindly guide me to achieve this. let Source = Json.Document(Web.Contents("https:/...
I have the same requirement as this
I need to extract the data of a specified web path but with the date range to change to the year to date to the current date, any idea how can I do this on PBI
http://xxxxxxx.com/itemGroupSalesScorecard.aspx?type=&company=can&businessUnit=&eDate=7/6/2023&sDate=7/1/2023&curr=CAD&custNum=100112&deliveryAddress=&mso=&productLine=&superGroup=&itemGroup=®ion=&salesGroup=&salespersonId=&whse=&custGroup=&item=&itemSubGroup=&vendNum=&reportingVendor=&vendName=&billToCountry=&shipToCountry=&shipToState=&segment=&commissionGroup=&custGroupSumm=&vendPool=