Forum Discussion
jbenson
Helper III
Helper IIIauto update Date from link
i have a link with a date in it, here is part of the link
reports/dailyPositionReport.page?grainDate=2021-01-04&commodities=C&locations=AL
how do i get the link to auto update based on the current date. is there a power query or a dax formula to get the date to change automatically so it pulls the correct data from the link each day?
2 Replies
- mahoneypat
Microsoft Employee
You can use this expression in the query editor to get the dynamic url where you need it.
= "reports/dailyPositionReport.page?grainDate=" & Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd") & "&commodities=C&locations=AL"
Regards,
Pat
jbensoni put in the part of URL you want me to use, i don't get any errors like the code is wrong it just clears the table so there is not data coming through
