Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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('...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

File attached here.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry to keep bothering

Still unsolved...

 

I edit the 'Date1'[Weekdays] format to whole number under query then reload to Pivot

But the measure 1 still shows Error