Forum Discussion
Solved
Today date on url
Dear experts, I'm trying to dynamically change the date on the url https://www.xe.com/currencytables/?from=DKK&date=2021-04-12#table-section to TODAY() with the correct format let
Sour...
You can this expression to dynamically add today's date.
"https://www.xe.com/currencytables/?from=DKK&date=" & Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd") &"#table-section"
Regards,
Pat
You can this expression to dynamically add today's date.
"https://www.xe.com/currencytables/?from=DKK&date=" & Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd") &"#table-section"
Regards,
Pat
Hi Pat
I did the exact same thing but when I publish to Power BI Service it isnt able to refresh and gives this issue:
Am I doing something wrong or is it normal behaviour?
Best,
Kaj