Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Data Update Error (Adds the data many times)

Hi everyone, I need to raise the following topic, as I have not been able to find the solution to my problem. I tell them to develop a financial model, which considers the budget for the year. The c...
lbendlin's avatar
lbendlin
Super User
2 years ago

Show the piece of your Power Query code where you apply the RangeStart and RangeEnd filters.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

RangeStart

RangeEnd

From the editor

I have the following query, the date range with incremental load is at the end of the query, by this I mean I have queries appended after the RangeStart and Range End condition.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Your parameters look good. Now show the query where you use them.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      Exieten queries based on SQL connection and excel file

      Both consultations were consolidated and annexed in a sheet called consolidated

      Now the report in the web service throws me

      January, it adds two months to the values, February gives it to me correctly and from March to December it doesn't give me values.

      In summary, the information in ppto 24 is only read for the months of January and February (January adds the values twice and February correctly)

      Filter from March to December

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Your filter is wrong. Only RangeStart should be inclusive. RangeEnd must be exclusive.

         

        each [RefDate] >= RangeStart and [RefDate] < RangeEnd