Forum Discussion
Solved
Average by category AND date
I'd like to calculate the average of CMg for every Bloque Horario category (A, B and C). I tried with the following measure which works only if select one month. However, my data has 10 years with 12...
Hi dvhez ,
From your comment: calculate only the block (A, B or C) corresponding to each month and year?
It now sounds like you do not need the Year|Month|Hour to average by but Year|Month ?
Is this the result you are after?
Jan 2019[ A] = 44.03 , Jan 2019 [B] = 43.0
Feb 2019 [A] = 45.62 , Feb 2019 [B] = 44.59If so here is the code for this one. Note, filter context is crucial when using these calculations
_Measure5 = CALCULATE ( AVERAGE(Data[CMg] ), FILTER ( ALL( Data ), Data[Bloque Horario] <= MAX ( Data[Bloque Horario] ) && Data[Date] <= MAX(Data[Date]) ))
As you can see from the image that i posted, the formula works fine. Try again.
Yes Ashish_Mathur , I'm trying. But am I doing it right? I entered two different measures in the way I exposed above but although they are exactly your formulas it doesn't work. "Measure" is equal to "Value" for every row.