Summarizing and Running Averages

Anonymous

For the RunningAverage Column use the expression

RunningAverage = Averagex (
Filter ( YourTable, YourTable[Pod] = Earlier ( YourTable[Pod]) && [Complete] <= Earlier([Complete]) ),
([Days])
)

For the Average of RunningAverage by Quarter create a summary table

 QtrRunningAvg= Summarize( YourTable, [Pod], [Quarter],  "QtrRunAvg",  Average(YourTable[RunningAverage])
                                                        )

Plot the values from summary table into a table chart you will see exeactly what you wanted.

Plot the values of RunningAverage from YourTable it will match your expectation.

If the above resolves your issue please accpet it as a solution and also give KUDOS.

Cheers

CheenuSing