Cumulative Date Count to Produce an S-Curve

[kavster]

I am trying to produce an S-Curve of Time (x-axis) against cummulative Date Count (y-axis); between two specific dates (which can vary with newly imported data).  These two dates I have as seperate measures (which seem to work) and are termed the Data_Data and BaseLineData Date.

So I have amongs others, a column of dates to count (this is the cumulative y-axis).

I have a seperate date table (from which I take time, i.e days, for the x-axis)

From many hours searching on this forum and refining probably 20 different formulas, the below is the best I have come up with for a cummulative count and it still doesn't work.

Any help would be very much appreciated as I have now just run out of ideas.

Thank you.

[kavster]

Thanks for the reply pbix file at link below.

https://1drv.ms/u/s!Av-JcS6SsCF4zHF0Qc5N0ZvpkavX?e=rJAITP

I think to keep it simple if someone can help me figure out why the matrix does not cumulative count between the data_date and BaseLineDataDate measures that would be great.  

[edhans]

What is the answer you are expecting? There are always 2,835 rows between the 6/13/2020 baseline date and the 12/13/2020 Data Date. The answer is always 2,835.I don't think that is what you want.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[edhans]

You are going to need to supply is with some usable data, and explain what you expect the results to be, and why what you have tried isn't working - i.e. it is returning X but you want Y.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.