Hello! I would like to ask how could I choose date range from a specific date until today? but I wish today's date will be dynamic and updated

&date_from=2020-12-01&date_to=2021-12-20&fields=date

i want the part 2021-12-20 change to date(today()) writen in excel functions

4:18 PM

Hi! Do you pull the data to google sheets?

4:19 PM

no in Power BI desktop

4:19 PM

You can delete “date_to” from URL, leave just “date_from” and it will take yesterday date by default

Almost all sources doesn’t return data for current date

4:21 PM

perfect! thank you very much

so the final will be from=2020-12-01&fields=date?

4:23 PM

yes

Does it work?

4:24 PM

just a moment to check it

4:24 PM

sure

4:24 PM