Can we make a variable parameter for use in data transformations

[PowerBI-ELM]

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,

[GilbertQ]

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.