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
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 Date is Date Type
Ok, Maybe because in my real data model it's grouped by Product ID and another column called "ReportingDate".
Is ReportingDate coming from the same table, or from other table connected via join?
If the latter is the case then all Table[Date] syntax should be replaced with TableName[ReportingDate]