Forum Discussion

sananthv's avatar
sananthv
Helper II
8 years ago

Incremental refresh duplicate

After setting up date/time parameters named RangeStart and RangeEnd, when i apply custom filter the "last changed" date column as indicated in the documentation https://docs.microsoft.com/en-us/power...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi sananthv

I can't reproduce your problem.



After setting up date/time parameters named RangeStart and RangeEnd, when i apply custom filter the "last changed" date column as indicated in the documentation, some records are getting duplicates.  

Records getting duplicates happens once you apply the custome filter instead of applying refresh, right?

How about applying this function in the Advanced editor?

Table.Distinct(table as table, optional equationCriteria as any)

Best Regards

Maggie