Incremental Refresh

[Anonymous]

Hello Community,

Is it possible to use the last refresh date as the start point and use today's date as the end date?

Thanks

Rob

[amitchandak]

Where you want to use.

Like

Measure =

var _max =maxx(Sales,sales[Date])

Var _tod = Today()

return

calculate([Sales],filter('Date',Date[Date]>=_max  && Date[Date]<=_today))

[Anonymous]

Thanks @amitchandak for your reply.

Really useful and one that I will keep for later use.

However, I think I need to expand on my original question.

To save on the time it takes to refresh a set CSV files which are updated daily, I am trying to solve the problem of only refresh the data from the last date the data was refreshed. Does that make sense?

Example

Last refresh date - 27/3/2020

Refresh today - 31/3/2020

New CSV files to update - 28/03/2020, 29/03/2020, 30/03/2020 and 31/3/2020

THE REFRESH SHOULD ONLY BRING IN THE DATA FROM THESE 4 CSV FILES.

I need to change the parameters to allow incremental refresh which is something else I need to understand more about but I am reading up on this but any hints would be appreciated.

I hope this makes sense and I am not even sure it will be possible but it would be awesome if there was a solution.

Thank you.