I am not sure if I understood your question correctly, but please try the below in order to create expected calcualted column. In my opinion, something like [project name] column has to be included when considering about conditions to add.
Cumulative Actual Energy V2 CC =
Absolute_Master_Table[Date] <= EARLIER ( Absolute_Master_Table[Date] )
= EARLIER ( Absolute_Master_Table[ProjectName] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.