Forum Discussion
Running Cumulative Total Weekly
I have a cumulative total in PowerPivot working like following:
Cumulative Time:=CALCULATE([SUM Actual Time],FILTER(ALL('TimeKeeping_Actual Time'),'TimeKeeping_Actual Time'[[Time]] Date] <= MAX('TimeKeeping_Actual Time'[[Time]] Date])))
But what I want is a running cumulative time total by week, looks like showing in red under column "Goal":
Can anybody help me to solve this problem?
Hi,
This measure works. Download the file from here.
Measure1 = if(ISBLANK([Actual Time]),BLANK(),CALCULATE([Actual Time],DATESBETWEEN('Date 1'[Date],CALCULATE(MIN('Date 1'[Date]),ALL('Date 1'[asBUILT Weekday])),MAX('Date 1'[Date]))))
Hope this helps.
19 Replies
Hi,
Share the link from where i can download your Excel file.
Hi Ashish,
Thanks very much for the help.
See whether you can open this link
My raw data for this excel is from Query, which is from a folder and automatic refresh once data been dropped into the folder.
Do I need to share the folder to you too?Hi,
In the Date Table, there should be a way to get the Week and Weekday columns (which are presently in your Timekeeping Table. If that can be done, the we will drag those two columns from the Date Table to the visual and write a simple measure to get your desired result.
Can you somehow do that?