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
Icon for Super User rankSuper 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
Icon for Super User rankSuper 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.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

      Weird that it is only broken for you.  Unless your colleage has experienced the same issue on their PC.  Maybe it's a timestamp/timezone issue?