Forum Discussion
Simple Rolling Sum not summing correctly
Super UserTried 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.
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
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?