Forum Discussion
Cumulative sum not calculating correctly
- 6 years ago
mafaber use MAX(dimcalendar[date]) straight in the filter don't store in the variable, you need to know when and where to use variable, in this case, you cannot use variables.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
mafaber use MAX(dimcalendar[date]) straight in the filter don't store in the variable, you need to know when and where to use variable, in this case, you cannot use variables.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
It did not allow me to use max(date) in a true/false expression the first time I tried, I'm not sure why. But anyway it is working now.
Thank you!