Forum Discussion

IC95's avatar
IC95
New Member
1 year ago

Running Total Not Working

Hi,    I hope someone can help me.   I have the Total Hours Efficiency Workcentre ( data I have)   I then have a measure with the Average Demonstrated Capacity(Last 3 Months)   Average...
vivek31's avatar
vivek31
Icon for Resolver II rankResolver II
1 year ago

HI IC95 ,

 

you can try this measure to create running total

running total = CALCULATE(SUM(Sales[SalesAmount]),
                          FILTER(ALL('Calendar'),
                          'Calendar'[DateKey] <= MAX('Calendar'[DateKey])))

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.