Solved: Incremental refresh set up

Anonymous · ‎10-23-2022

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?

Jihwan_Kim · ‎10-24-2022

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

View solution in original post

Jihwan_Kim · ‎10-24-2022

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page