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,

 

I want those two columns to be added to the Date Table.  Your relationship for now is just fine.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

And one more question:

When I add Date from Query, the query name is still "Date".

But when I add it into Pivot Model, the table name is now "Date 1".

When I tried to edit and rename it, the dialogue box says I should edit it under query rather than in Pivot.

But I don't know how to in Query.

Would you please help on this one too?

Many tks.