Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cumulative Data sum by day

Hi Every one, I developed a calculated column as below for cumulative line to sum actual man hours , but it doesnt sum up at all !  Cumulative Actual =  CALCULATE (    sum ( 'PBI LabourCode_Actu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Create a Calendar Table and build a relationship from the WorkDate column of the PBI LabourCode_Actual Table to the Date column of the Calendar Table.  In your visual, drag Date from the Calendar Table.  Write this measure

     

    Cumulative Actual =
     CALCULATE (
       sum ( 'PBI LabourCode_Actual'[ActualsManHours] ),DATESYTD(Calendar[Date],"31/12"))

     

    Hope this helps.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

Modify the measure as below and check if it can meet your requirement.

Cumulative Actual =
CALCULATE (
SUM ( 'PBI LabourCode_Actual'[ActualsManHours] ),
ALLEXCEPT ( 'PBI LabourCode_Actual', 'PBI LabourCode_Actual'[Date] )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-yuta-msft 

    No, unfortunately it doesnt work ! it doesnt sum up . look at the below result.