Forum Discussion
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 ...
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
Super User
Super UserWeird 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?