Forum Discussion
ewakol
1 year agoHelper II
Visual calculation - running sum trouble or pbi bug
Hello, i create running sum using visual calculaction, and have strange problem. Data are for two companies, for one visual calculaction worsk fine, for second the first value is not correct (mark o...
ewakol
1 year agoHelper II
Hello,
and thank you for reply thanks that i found what is a problem, so i create visualisations based on DAX calendar which cut data to last 12mc + 12mc
its works very good, because i don't want to show data from other periods, instead of running sum, this one must be calculated from the beginning, do you have any idea how cloud i solve this?
jeroenterheerdt
1 year agoMicrosoft Employee
I am not sure I exactly follow what you want, but it looks to me like you are trying to do a running sum over data that is not on the visual. this will not work. RUNNINGSUM only operates over data that's in the visual. Please share the DAX you are using for RUNNINGSUM as well as the data so we can help.