Forum Discussion
Solved
Running total, by Project ID column
Hi Guys I Need the running totals each month in a column for the Days column grouped by Project ID. Thanks Guys Project ID Days Date Running Total Days AA 16 01/01/2018 16 ...
they do work for me - is the Table[Date] of data type Date? Other than that I cannot think of other reason for it not to work
Column =
CALCULATE (
SUM ( [Days] ),
FILTER (
ALLEXCEPT ( Table1, Table1[Project ID] ),
[Date] <= EARLIER ( [Date] )
)
)No that never worked, That's what I tried myself first.
