Calculated column to show Sum of values by month and by id

[AndreDeLuca]

What i need is to create a conditional column that indicates if a person is over, under or full allocated for the month. For that condition we have two fields, "hoursPlanned" and "hoursExecuted". So what i thought was to create a SWITCH that would be something like this: 

SWITCH(TRUE(),

 f_Horas[hoursPlanned] = f_Horas[hoursExecuted], "Full",

 f_Horas[hoursPlanned] < f_Horas[hoursExecuted], "Over",

 f_Horas[hoursPlanned] > f_Horas[hoursExecuted], "Under")

This works, but in row context. I need it to be on person/month context, so i can analyse the situation for any person in any specific month. Since we have multiple lines for the same person on the same month,  i need to change the "f_Horas[hoursPlanned]" and "f_Horas[hoursExecuted]"  fields for a formula that calculates the total amount of hours per person and per month, and i don't know and couldn't find how to do that, so if anyone happens to have the solution i'll be very grateful. 
Thanks for the attention, any questions i'll be happy to answer.

[AndreDeLuca · Accepted solution]

I manage to create a formula that worked, here it is:

FULL/OVER/UNDER =

var p = CALCULATE(SUM(f_Horas[HorasPlanejadas]), ALLEXCEPT(f_Horas, f_Horas[Colaborador], f_Horas[MesAno]))

var r = CALCULATE(SUM(f_Horas[HorasRealizadas]), ALLEXCEPT(f_Horas, f_Horas[Colaborador], f_Horas[MesAno]))

var res =SWITCH(TRUE(),

 p = r, "Full",

 p < r, "Over",

 p > r, "Under")

return res  

Hope someone can benefit!