S-Curve for project management

[Anonymous]

Hi,

I'm struggling to visualize a cumulative line for forecasted work. 

My data is as follows:

• For each task, there is the expected start and expected finish and the total amount of days in between
• And as an example, if I'd like to calculate how much work should have be already donde by today, this would be a simple calculation and is in Expected work as of Today 

What I want to to, is to calculate that expected work as of today in a dynamic way bu date, which is a S-Curve or cumulative expected work by dates in the X-Axis as this type of lines below:

Does anybody know how to do that, please?

Thanks in advance!

[Anonymous · Accepted solution]

Try the following measure... Modify it according to your requirement.

Work Status = 
VAR WorkTab = ALLSELECTED(WorkTable)
VAR MaxDate = MAXX('Calendar','Calendar'[Date])
VAR WS = 
    SUMX(
        FILTER(
            WorkTab,
            [Start]<MaxDate),
        INT(MaxDate-[Start])
    )
RETURN
WS

The calendar does not have any relationship with the other table. It is an independent table used only for taking the max date of each month in your graph based on the context.