Add a static value to Calculated measure

[Sandhya877]

I am trying to create a measure with the below logic Add 10 till it reaches 140 and then repeat the same value till a particular date.

Date	Current Value	Expected Result
01/01/2023	100
02/01/2023		110
03/01/2023		120
04/01/2023		130
05/01/2023		140
06/01/2023		140
07/01/2023		140
08/01/2023		140
09/01/2023		140

[v-shex-msft]

HI @Sandhya877,

You can try to use the following measure formula to get the cumulative value until the target:

formual =
VAR currDate =
    MAX ( Table[Date] )
VAR _startValue =
    CALCULATE ( MIN ( Table[Current] ), ALLSELECTED ( Table ) )
VAR _startDate =
    CALCULATE (
        MIN ( Table[Date] ),
        FILTER ( ALLSELECTED ( Table ), [Current] <> 0 )
    )
RETURN
    MIN ( _startValue + DATEDIFF ( _startDate, currDate, MONTH ) * 10, 140 )

Regards,

Xiaoxin Sheng

[Sandhya877]

Thank you.

[Greg_Deckler]

@Sandhya877 What's your date format? mm/dd/yyyy or dd/mm/yyyy?

[Sandhya877]

@Greg_Deckler mm/dd/yyyy