Forum Discussion
Running total, by Project ID column
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
Stachu.
None of those worked, In the measure, it gives me the same days as they are in each month, no rolling totals.
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]
I've got it working, I've got a further filter, which divides the data by three, If I filter on it manually and divide your column y 3, I get exactly what I'm looking for.
Is there obviously a way to filter on two columns?