Forum Discussion

Frequent Visitor

9 years ago

Rolling Percentage On Time

Hi. I know some posts have addressed the issue, but I still can't get it to work for my specific example. In Excel, I have data by month, destination, and carrier, a number of deliveries, and num...

Need Help

v-sihou-msft

Microsoft Employee

9 years ago

LEC

In this scenario, I suggest you add a month number in your table for cumulative calculation. You can create following measures to calculate running total late and delivery.

running total late = CALCULATE(SUM('Table'[Late]),FILTER(ALL('Table'),'Table'[Month Number]<=MAX('Table'[Month Number])))

running total delivery = CALCULATE(SUM('Table'[Delivery]),FILTER(ALL('Table'),'Table'[Month Number]<=MAX('Table'[Month Number])))

Then calculate the percentage:

Pct = 1 - 
CALCULATE(SUM('Table'[Late]),FILTER(ALL('Table'),'Table'[Month Number]<=MAX('Table'[Month Number])))
/
CALCULATE(SUM('Table'[Delivery]),FILTER(ALL('Table'),'Table'[Month Number]<=MAX('Table'[Month Number])))