Forum Discussion

hhdez's avatar
hhdez
Regular Visitor
4 years ago
Solved

Cumulative Total (doesn't work)

Hi,

So I've been trying to get a running total going for a table, and although I've read all the messages in here, I haven't been able to get it to work.

This is my data:

The colum TOTAL BUILD PLAN is where I am trying to calculate the running total.

This is the formula I am using:

TotalBuildPlan = 
CALCULATE(
  SUM(Table1[ Build Plan]),
   Filter(
   ALL(Table1[Week]) ,
   Table1[Week] >= MIN(Table1[Week]) ) )

What am I doing wrong?

Thanks for the help

Need Help
  • PijushRoy's avatar
    PijushRoy
    4 years ago

    Hi hhdez 

    Please try (hope you have date col in table1)
    VAR _buildplan = SUM(Table1[ Build Plan])
    RESULT
    CALCULATE(
    _buildplan,
    Filter(
    ALL(Table1[Date]) ,
    Table1[Date] > MAX (Table1[Date]) -7 &&
    Table1[Date] <= MIN (Table1[Date]))

     

    If you have any question, please let me know.
    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

     

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    4 years ago

    Hi hhdez 

    Please try (hope you have date col in table1)
    VAR _buildplan = SUM(Table1[ Build Plan])
    RESULT
    CALCULATE(
    _buildplan,
    Filter(
    ALL(Table1[Date]) ,
    Table1[Date] > MAX (Table1[Date]) -7 &&
    Table1[Date] <= MIN (Table1[Date]))

     

    If you have any question, please let me know.
    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos