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('...
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.
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?