Forum Discussion
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 BUI...
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
It did. Thanks!