Power BI S-Curve

Question

HiIn the below image showing Actual values if not avalaible showing 0 in i need to show&nbsp; insted of 0 Previois Cumilative value.&nbsp;&nbsp;&nbsp;S-Curve(Actual) = VAR A = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNT(Tasks[TaskActualFinishDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(ALLSELECTED(Tasks),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Tasks[TaskFinishDate]) &lt;= MAX(Tasks[TaskActualFinishDate]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))VAR B = CALCULATE(COUNT('TaskBaselines'[TaskBaselineFinishDate]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ALLSELECTED('TaskBaselines'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MAX(TaskBaselines[TaskBaselineFinishDate])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ))VAR S_Curve = (A / B) * 100&nbsp; &nbsp;RETURN S_Curve&nbsp;&nbsp;please help me return value if Var A&nbsp; is empty then show previous Cumilative value&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;sprao&nbsp;,
&nbsp;
According to your code, I suggest you to try to create a Calendar table with continuous date in it.
For reference:
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
Then create the measure by [Date] in this Calendar table.
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Power BI S-Curve

1 Reply

Related content

S - Curve

Creating S-curve visual in Power BI

How to create the S curve in Design

Help Needed – Incorporating Task Duration Into Weighted S-Curve (Power BI / Data Modeling)

Standard S-Curve Measure