Forum Discussion

hrics12's avatar
hrics12
Frequent Visitor
2 years ago
Solved

Dynamic dates to pull GeoTab data into powerBI.

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

Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    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)

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    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's avatar
      hrics12
      Frequent Visitor
      2 years ago

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