Forum Discussion

M-M-P's avatar
M-M-P
Icon for Helper III rankHelper III
1 year ago
Solved

After data refresh, spikes are seen in the data.

I have a problem for which I cannot find a solution. When I publish to Power BI Service everything looks fine, see figure 1. So after an auto refresh at night, data spikes are now seen at 1 a.m. ev...
  • lbendlin's avatar
    lbendlin
    1 year ago

    You made a mistake in the definition of the RangeEnd filter.

     

    Between RangeStart and RangeEnd only one of them can be inclusive (usually RangeStart). The other one must be exclusive

     

    RangeStart <= Date

    Date < RangeEnd