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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

Cumulative forecast

Hello!!

I want to create a table with measurements of a cumulative total of forecast per product, where I put the X would be the product.

Captura.JPG

I would like a third column with the cumulative total forecast each month, example in the case of the second product x would be:

January 52 February 91 March 130

I attach my forecast table

https://distribuidoradonramon-my.sharepoint.com/:x:/g/personal/daniel_lopez_dontequila_com_mx/ET5C_l...

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please try below.

expected measure: =
CALCULATE ( SUM ( TableName[Cajas] ), TableName[Mes] <= MAX ( TableName[Mes] ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @Syndicate_Admin ,

 

Whether the advice given by @Jihwan_Kim  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry

Jihwan_Kim
Super User
Super User

Hi,

Please try below.

expected measure: =
CALCULATE ( SUM ( TableName[Cajas] ), TableName[Mes] <= MAX ( TableName[Mes] ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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