Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Comparing averages to a baseline date

Hello everyone! I want to take some averages that come from a baseline date, then take averages from all other dates and subtract the second one from the first. I have created a formula that is sh...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

az38  I use this one

 

Average Event Time = AVERAGE('Runtime Info'[Event Time])
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

ypur statement looks good enough

didn't your try to debug? whats component is wrong? baselineAverage  or currentAverage?

also, try this

AET Difference with Baseline =
VAR baselineAverage = CALCULATE(AVERAGEX(FILTER(ALL('Runtime Info'), [Date] = DATE(2020, 04, 03)), [Event Time])
VAR currentAverage = CALCULATE(AVERAGE([Event Time]))

RETURN
baselineAverage - currentAverage