Incremental dataRefresh using current date as dynamic parameter

[CastroRibeiro]

I'm trying to create an incremental update, where the RangeEnd will be the current date, I've tried to create it as a query, but it doesn't work, it doesn't enable the option to activate the incremental update.

Any help?

RangeEnd = Date.From(DateTime.LocalNow())

= Table.SelectRows(#"Tipo Alterado", each [Date Inicio Viagem] >= RangeStart and [Date Inicio Viagem] <RangeEnd)

[amitchandak]

@CastroRibeiro , I usually follow the approach given in this document

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh