Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

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.

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_lxJyF1BtofKqqfYppoBlZBT3txX6I1WY6dJXfgEmg?e=lDcoaE

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please try below.

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

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    Please try below.

    expected measure: =
CALCULATE ( SUM ( TableName[Cajas] ), TableName[Mes] <= MAX ( TableName[Mes] ) )
  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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