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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur 

Thanks mate!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    You are welcome.