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 to...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please try below.

    expected measure: =
CALCULATE ( SUM ( TableName[Cajas] ), TableName[Mes] <= MAX ( TableName[Mes] ) )
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] ) )