Dynamic dates to pull GeoTab data into powerBI.

[hrics12]

I'm trying to pull a table called "Trips" from GeoTab in an API call. When I set the search in the "params" equal to a date in the past it will pull the live data from that date to the current date. I need to be dynamic so it will always pull the data from 32 days ago. Everything i've tried just gives me blank data in the report. It also loads data from 2015. Does anyone know what to put and where to put some code in the advanced editor so it will always call for data from 32 days ago? Anything will be helpful

[GilbertQ · Accepted solution]

Hi @hrics12 

What you can do in power query is to use a function that will always go back to the past 32 days. Here is an example below. Put this code below where you are passing the parameter

Date.AddDays(DateTime.LocalNow(),-32)

[hrics12]

Thank you! This is what I needed. I was just adding other stuff. This was simple and worked great