Forum Discussion
Solved
BI Measure
It's so easy on exel...but now on BI I'm trying to create aggregated measure - see below in excel. Any help appreaciated! Thank you
Good morning Thunders,
We need more details for the Quota, is it always 2500 ? or it's change by month ?Why you choose r
You can for exemple use something like that :
__Mesure =
Var Total = CALCULATE(SUM(Quota), ALL(Dates) // it will calculate all total of the quota
Var Aggre = CALCULATE(SUM(Sales), Dates[Month] >= EOMONTH(MAX('Dates'[Month]), -3) //Calculate the sum of every 3 last months
RETURN DIVIDE(Aggre, Total)
