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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Syndicate_Admin
Administrator
Administrator

Accumulated sum goes wrong

Hello!

I have a "Product Sale" table with a "Total Boxes" column

I try to add the accumulated "Total Boxes" per month, I tried with the following function: but it goes wrong.

ACCUMULATED = CALCULATE(SUM(SaleProducts[Total Boxes]),
FILTER(ALL(VentaProductos),
SaleProducts[Date of acceptance]<=Max(SaleProducts[Date of acceptance])))

Captura de pantalla 2022-08-31 142541.jpg

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

I achieved this with:

ACCUMULATED = TOTALYTD([Boxes Sold],Calendar[Date])

View solution in original post

6 REPLIES 6
Syndicate_Admin
Administrator
Administrator

I achieved this with:

ACCUMULATED = TOTALYTD([Boxes Sold],Calendar[Date])
jgeddes
Super User
Super User

How are you calculating Cajas Vendidas?

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





jgeddes
Super User
Super User

Are you expecting the result to look like...

jgeddes_0-1661975981819.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





How did you do it?

I used

CALCULATE(

SUM(VentaProductos[Cajas Vendidas]),
FILTER(ALL(VentaProductos), VentaProductos[Fecha de aceptacion] <= MAX(VentaProductos[Fecha de aceptacion]))
)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Yes, that's what I hope

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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