Getting a running total of rows vs 100% Complete

[Brian_]

I know I'm just missing something dumb here, but I can't seem to figure it out and all of my seaches have almost gotten me there.

I'm trying to get a running total % of a % of completion on a project.  The below is where I'm at in Power BI and the Excel snippet is what I'm trying to do.  I want the measure of each submittal to sum up with the previous submittals, eventually getting to 100%.  So the secondary y-axis in BI would just run from 0% - 100% as each submittal is submitted.  Help, please!

[Brian_]

Yet another stab at it.  I just want the second y-axis to show 0% - 100%.  It does NOT want to cooperate.

ETA:  Here is my %ManHrsCalc if that makes a difference.  48164 is the total forecasted man hours for the job, btw:

= Table.AddColumn(#"Changed Type2", "%ManHrsCalc", each if [SumActManHrs] > 0 then [#"%ManHoursTotal"] else [SumFcManHrs]/48164 )

[NiharAgrawal]

Hey Brian,

You can create a separate table for the dates, use that as the x-axis and then write the formulae for your actual and cummulative values on top of it. Please see snapshots below

No relation between two tables

Formulae

Hope this helps.

[Brian_]

So close!  I can get that to work in a separate tab in BI, but I can't manage to combine it with my original tab with the totals of EstManHrs, FcManHrs and ActManHrs.  There has to be a way.  I'm running out of walls to bash my head against!

ETA:  And the dates between the two tables are exactly the same, if that helps.  Tried just putting the cumulative in the original visual as a second y-axis and it goes back to not showing as cumulative.  Grrr....