I have to pull a data from a websource that provides a webAPI to downlood the data, here's a tamplate:
The problem is that, i need to insert a data range on this link, as you can see in the line "from=2018-04-09&to=2018-05-09".
This data will be used to make reports from a certain date up to today's date. But i need to do it without having to change the url everyday.
Is there any way of doing this using DAX?
Here is an example of a pull:
I would like the data from July ( 2020-07-01 ) until this date. How to do that?
You can create two parametrs FromDate and ToDate for the same and use it in the example to pull
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
I need the date in the format yyyy-mm-dd, how would this be?
FORMAT(TODAY(), "YYYY-MM-DD") is not working for me, see how it looks:
"....from=2020-07-01&to="& FORMAT(TODAY(), "YYYY-MM-DD")&"&additional_fields=keyword_id,store_reinstall,...."
@badluckmathReplace the date range text with the following text. If you created a parameter. replace #date(2020,7,1) with the parameter name
= ".... from=" & Date.ToText(#date(2020,7,1),"YYYY-MM-DD")& "&to=" & Date.ToText(Date.From(DateTime.FixedLocalNow()), "YYYY-MM-DD")
If my answer was helpful, consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this answer 🙂
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.