Visual Calculation

[AllanBerces]

Hi good day can someone help me on my visual calculation, on my S-Curve i want the actual cumulative line to be up to the current week. the line on the red box should not display.

Thank you

[rohit1991]

Hi @AllanBerces 

To stop the cumulative Actual line from extending into future weeks, you can create a measure that only shows values up to the last week with actuals:

Last Actual Date =
CALCULATE (
   MAX ( 'Data'[Date] ),
   FILTER ( ALL ( 'Data'[Date] ), [Actual] > 0 )
)

**bleep** Actual (shown) =
VAR lastDate = [Last Actual Date]
RETURN
IF ( MAX ( 'Data'[Date] ) > lastDate, BLANK(), [**bleep** Actual (raw)] )

Now use **bleep** Actual (shown) in your chart instead of the raw cumulative measure. This way, the line will stop exactly at the current week with data and won’t display beyond it.

[Shahid12523]

Use this DAX so the Actual cumulative line stops at the last actual week:

**bleep** Actual =
VAR _lastWeek =
MAXX ( FILTER ( ALL ( TableName[WeekID] ), NOT ISBLANK ( TableName[Actual] ) ), TableName[WeekID] )
RETURN
IF (
MAX ( TableName[WeekID] ) <= _lastWeek,
CALCULATE (
SUM ( TableName[Actual] ),
FILTER ( ALL ( TableName[WeekID] ), TableName[WeekID] <= MAX ( TableName[WeekID] ) )
)
)

[AllanBerces · Accepted solution]

Hi @rohit1991 @Shahid12523 thank you for the reply, a got the solution.

**bleep** Actual = IF([S.No.]<= WEEKNUM(TODAY()), RUNNINGSUM([Actual]))