Forum Discussion
mmowrey
Helper I
Helper IRunning total stops calulating.
I have a running total that will only work for a range of 7 days.. if i add any more days it just keeps repeating the last value
Monthly Running Total Goal (RBC) =
CALCULATE(
[Red Cell Projected],
FILTER(
ALLSELECTED(BloodDrive[DriveDate]),
BloodDrive[DriveDate]<= MAX(BloodDrive[DriveDate])
)
)
3 Replies
- amitchandak
Super User
mmowrey , do have data for those additional days ?
Assuming - Red Cell Projected is measure
This seems fine. or try like
CALCULATE(
[Red Cell Projected],
FILTER(
ALL(BloodDrive[DriveDate]),
BloodDrive[DriveDate]<= MAX(BloodDrive[DriveDate])
)
)If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
mmowreyThere is data for those other days.. and if i just run for those days it calculates.. It just stops after 7 days
