Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Cumulative Sum depending on two columns

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

mjesusmar_0-1593376867396.png


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

mjesusmar_1-1593377136758.png

 

Ther formula is:

mjesusmar_2-1593377163992.png

Hope someone can help me!
Thanks in advance

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

mjesusmar_1-1593379316499.png

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

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

mjesusmar_1-1593379316499.png

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.