How to make range parameter to dynamically use current date?

[StrPod]

Hi, I have implemented power bi incremental refresh using the RangeStart and RangeEnd parameter. is there a way to make the RangeEnd parameter to dynamically use the current date (DateTime.LocalNow()). The parameter value box only takes datetime value.

the reason I want this is so that when I get a new data and I want to do transformation I don't want manually change the RangeEnd date everytime to see the data in PQ editor preview and the data view.

[lbendlin]

That's not how incremental refresh works.  The values for RangeStart and RangeEnd in Power Query have absolutely no correlation to the partition rules created in the Power BI interface for your table  (say, keep last 5 years and refresh last two months). These values in Power Query can be anything and are usually used to give the report developer just enough data to work with the visuals etc (for example when you need to do a Year over Year calculation).

There is a special case when the RangeStart is in the future but you still need to fill the partition. That is handled via XMLA script.