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 ...
If you are going to have a table\matrix that is by day, and you have your daily goal, you could just multiply the daily goal by the month day:
Get day of month: DAY('Calendar'[Date])
Get goal value rolleed up:
=DAY('Calendar'[Date]) * DailyGoal