Home Forums Power Pivot Limiting data by date

This topic contains 1 reply, has 2 voices, and was last updated by  tomallan 1 week, 3 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #9756

    lilzenbca
    Participant
    • Started: 8
    • Replies: 6
    • Total: 14

    I have an interesting problem.

    My boss wants to be able to limit the data that’s pulled based on a date selection from within a Power BI report. Is there a way to pass a date to the Power Query to only pull date through a certain date?

    My issue is that I’ve got a R script that runs an ETS forecast on the data that’s pulled, so in order to have the script forecast correctly, the data needs to be limited from the source.

    If there’s a better way to run the ETS forecast without using the R script in Power Query, I’m all ears. At that point, if it’s calculated within a report, limiting by date looks easier.

     

    Thanks.

     

    Brandon~

    #9757

    tomallan
    Keymaster
    • Started: 9
    • Replies: 2244
    • Total: 2253

    To my knowledge, there is not a way to transfer slicer or other filter selections from a Power BI report and create parameters for a query against the data source. You have to be inside the query editor to work with parameters against the data source.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.