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.

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Please try changing your logic as below

 

Cumulative Actual = 
 CALCULATE (
   sum ( 'PBI LabourCode_Actual'[ActualsManHours] ),
   FILTER (
      ALL ( 'PBI LabourCode_Actual'),
     'PBI LabourCode_Actual'[WorkDate] <= EARLIER ( 'PBI LabourCode_Actual'[WorkDate] )
)
)