Cumulative forecast

[Syndicate_Admin]

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.

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...

[v-henryk-mstf]

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 · Accepted solution]

Hi,

Please try below.

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