Forum Discussion
Running total?
So I have a dates, hour, and goals query. A monthly goal is August "3000" hours, so my daily one is 96.77. I am trying to get my goals column to increase by 96.77 every day of August until it's ...
Hi michellerosen,
Did you means use target table to create the rolling total calendar?
If this is a case, you can refer to below sample.
1. Calculate column daily target:
Daily = [Total Goal]/DAY(DATE([Date].[Year],[Date].[MonthNo]+1,1)-1)
2. Rolling target calendar based on target table.
CALENDAR = ADDCOLUMNS(SELECTCOLUMNS(CALENDAR(DATE(2017,1,1),TODAY()),"Date",[Date],"Daily Goal",LOOKUPVALUE(Records[Daily],Records[Date],DATE(YEAR([Date]),MONTH([Date]),1))),"Rolling",DAY([Date])*[Daily Goal])
If above not help, please share some sample data to analysis.
Regards,
Xiaoxin Sheng