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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.