Forum Discussion

MatteMatto's avatar
MatteMatto
Frequent Visitor
6 years ago

Simple Rolling Sum not summing correctly

Hi All,   I have been struggling to get my Rolling Sum Running despite doing it multiple different ways. It seems that its not picking up all the dates that are within the period that i have asked ...
lbendlin's avatar
lbendlin
Super User
6 years ago

Just tried your Running Total query and it seems to work fine. How does it look on your side?

 

MatteMatto's avatar
MatteMatto
Frequent Visitor
6 years ago

Wow, that grinds my gears a bit i have just written it in word for word and look at what i get :

 

 

In that case, the only difference is that maybe the data is in direct query? could that effect this?

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    That is indeed bizarre.  Let me try direct query on my side, but I am pretty sure the reason is elsewhere.

     

    Can you check that your "hourly rainfall" column is indeed set to "sum" ?  Or is it a measure that is influenced from elsewhere?

    • lbendlin's avatar
      lbendlin
      Super User
      6 years ago

      Tried with Direct Query, got the same result as I got with import. The only tricky part was to find the right column type for the NZDT column in my database, but I don't think it has an impact. We need to look elsewhere.

      • MatteMatto's avatar
        MatteMatto
        Frequent Visitor
        6 years ago

        Hi,

         

        I ended up having chat with a Developer colleague and we worked through a lot of different options looking into why it was missing certain rows of data, He thinks that we have hit a brick wall in power bi itself as it was not properly pulling all the timestamps, In the end the answer was to move the cumulative calculation into the SQL Query. Sadly this still leaves power bi broken as far as im concerned.