Hoping this is an easy fix. I have a rangestart and rangeend set up for my incremental refresh to work. I also have a simple query list.max(Sales Info[LoadDate]) query to influence my date table. I want this max load date to be my ‘current date’ in my date table as all of my offset m codes are based on my ‘current date’.
The problem I need to figure out is how to have a dynamic RangeEnd? The original RangeEnd parameter I had was 23/08/2021, which once I loaded to the Service becomes void and data comes through as normal. However, as my offsets are based on the “current date” which is 23/08/2021 (RangeEnd parameter) my offsets are not updating. I cannot convert my RangeEnd parameter to = my Lade Date query as this forms a cyclic error.
Anyone have any thoughts?
EnterpriseDNAquery1309.pbix (2.7 MB)