Forum Discussion
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...
az38
Community Champion
Community ChampionAnonymous
no. it means you need average by Query and date
so, it shuld look like
AET Difference with Baseline =
VAR baselineAverage = CALCULATE(AVERAGEX(FILTER(ALL('Runtime Info'), [Date] = DATE(2020, 04, 03)), [Event Time])
VAR currentAverage = CALCULATE(AVERAGE('Runtime Info'[Event Time]), ALLEXCEPT('Runtime Info', 'Runtime Info'[Query], 'Runtime Info'[Date]))
RETURN
baselineAverage - currentAverage
Unfortunately nothing changed. Still not the correct result. Anyway I believe it is frustrating enough 😛 I shall try out some other stuff to see if they work and if not I'll see what I can do. If you have any other ideas please don't hesitate to port them, or if not thank you anyway for your help and patience!