Forum Discussion
Using Running Total in Calculations
Hi, I have a measure that calculates the running total of no. of companies. I want to multiply this figure for a given year by another amount, e.g. Year Running Total Amount Desired Res...
v-jiascu-msft - good suggestion. I haven't used that function before.
Unfortunately, it didn't work in this case. I added all the columns I wanted to be able to filter, excluding the date column. The problem is if I exclude the date column, I only get one result, regardless of the year. And if I include the date column as one I want to be able to filter, we're back to the original problem.
Thanks!
