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 ...
The solution worked but only if I used the dates I made in the Daily Table. It wouldn't work with the dates in my Dates table, and for some reason when I added my dates in the Daily Table they would all be for the same day regardless of filter.
Any chance you can share a copy of your PBIX file so we can review? As you are looking for Day level detail, you'll have to have a Date table, but any Date table (as long as it has 1 entry for every date) should have worked just fine...?
FOrrest