Actual vs Planned - S-curve visual - 1 curve is decreasing [Power BI desktop)

[Dror]

Dear Forum [Power BI Desktop],

I'm facing an issue with trying to create an S-curve (cumulative) of Planned vs Actual.
Currently these is the curves "Look" (Line and Clustered column chart),

The Yellow curve is for the "planned" activities and the Red curve is for the "Actual" activities.
I'm using XSL as the Database, see below the columns,
SubmissDate    S#    Planned Date  P#    Submission no.

02/01/2024	1	31/12/2023	1	S1
10/01/2024	1	09/01/2024	1	S2
15/01/2024	1	05/01/2024	1	S3
01/02/2024	1	03/02/2024	1	S4
15/02/2024	1	10/03/2024	1	S5
05/04/2024	1	05/03/2024	1	S6
10/04/2024	1	31/03/2024	1	S7
02/05/2024	1	16/04/2024	1	S8
02/05/2024	1	16/04/2024	1	S9
02/05/2024	1	16/04/2024	1	S10
02/05/2024	1	16/04/2024	1	S11
02/05/2024	1	16/04/2024	1	S12
02/05/2024	1	16/04/2024	1	S13
03/05/2024	1	20/05/2024	1	S31
03/05/2024	1	20/05/2024	1	S32
03/05/2024	1	31/05/2024	1	S33
10/05/2024	1	31/05/2024	1	S42
15/05/2024	1	16/04/2024	1	S14
15/05/2024	1	16/04/2024	1	S15
15/05/2024	1	16/04/2024	1	S16
15/05/2024	1	16/04/2024	1	S17
15/05/2024	1	20/05/2024	1	S18
15/05/2024	1	20/05/2024	1	S19
19/05/2024	1	20/05/2024	1	S20
22/05/2024	1	20/05/2024	1	S21
22/05/2024	1	20/05/2024	1	S22
22/05/2024	1	20/05/2024	1	S23
06/06/2024	1	31/05/2024	1	S41
23/06/2024	1	20/06/2024	1	S24
23/06/2024	1	25/06/2024	1	S25
		30/06/2024	1
		30/06/2024	1
		30/06/2024	1
		30/06/2024	1
		01/07/2024	1
		01/07/2024	1
		01/07/2024	1
		01/07/2024	1
		30/07/2024	1
		30/07/2024	1
		30/07/2024	1

I've been trying to play with the Running Total measures - didn't work.

The visual build is,

Once I'm putting the 'Planned date' as X-axis, the 'PlannedS#' working but the 'ActualS#' curve is decreasing after couple of months, and vise versa [means if I put the 'Actual date' as X-axis].

I read many past posts regarding this topic,
- I tried to create another 'KeyDate' column in diffrenet table with USERRELATIONSHIP to this table - same results.

- Checked the Data.

- Played with diffrenet types of Running totals.

Not sure what I'm doing wrong. 

Please support.

[amitchandak]

@Dror , Join both Dates with date of date table. One join will be inactive, for that, you can use userelationship in measure. You have use Date from Date table in axis and slicers

related example

CALCULATE(COUNT(Employee[Employee Id ]),USERELATIONSHIP(Employee[End Date],'Date'[Date]),not(ISBLANK(Employee[End Date])))

here end date has inactive join

HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

[Dror]

@amitchandak Thanks for your quick reply.
I did exactly as you suggested, see below the screenshots (Created a 'Date' table + relationships and did the measure),

Created a measure:

SubCurve = CALCULATE(COUNT(Submittals[Submission no.]),USERELATIONSHIP(Submittals[Submission Date],'DATE'[Date]),not(ISBLANK(Submittals[Submission Date])))

And this is the curve I reciving,

May you suggest what I did wrong?