Forum Discussion
Incremental refresh set up
Hi, I am trying to set up an incremental refresh like this
On my report, there is a measure like this
Total Qty = SUM(Table[Quantity])
After publish this report to BI service, the measure's value has double up somehow (e.g "1" in BI desktop, "2" in BI service)
May I know if anyone come accross with this case and how I could solve?
Hi,
I am not sure, but sometimes in my cases, in Power Query Editor, when setting up the filter by parameters, one has to be greater than, and the other has to be less than or equal to (or other way round).
It cannot be greater than or equal to and less than or equal to (equal cannot be on both side).
I hope this helps.
Thank you.
2 Replies
Hi,
I am not sure, but sometimes in my cases, in Power Query Editor, when setting up the filter by parameters, one has to be greater than, and the other has to be less than or equal to (or other way round).
It cannot be greater than or equal to and less than or equal to (equal cannot be on both side).
I hope this helps.
Thank you.
Jihwan_Kim your solution has prefectly solved the issue.