Cumulative Sum depending on two columns

[mjesusmar]

Hello all,

I'm new in the community, so i dont really know how to use the forum 😞 hope i'm not causing any trouble with the topic.

Thing is, i have the following table in Power BI

What i'm looking for is to Sum, depending on the date and the column "Gerente FAAS". The field containing the values to sum is "Venta Meta Semanal"
so, i need to create a new column that should give me the same result as this one in excel

Ther formula is:

Hope someone can help me!
Thanks in advance

[mjesusmar · Accepted solution]

Solved! Gonna leave the answer, hope it can help somebody

Venta Estimada = CALCULATE(SUM(Progreso[Venta Meta Semanal]);FILTER(Progreso;Progreso[Gerente FAAS]=EARLIER(Progreso[Gerente FAAS]));Progreso[Semana]<=EARLIER(Progreso[Semana]))

Thanks!