Forum Discussion

PowerBI-ELM's avatar
PowerBI-ELM
Helper I
4 years ago

Can we make a variable parameter for use in data transformations

In my review of using Incremental Refresh datasets I know I need to set up the parameters RangeStart and RangeEnd.  So far this has worked by setting them to hard coded dates.

 

Is there a way to set them to a calculated value.  For instance if i want the date range in the parameters set to 1 year ago to today?

 

Thanks,

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Hi PowerBI-ELM 

     

    You could do it via Power BI Desktop.

     

    If you have Power BI Premium Per User or Premium, you connect with Tabular Editor and update it that way?


    Just make sure you have a backup of the database before making any changes.