Forum Discussion
Add a static value to Calculated measure
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 ...
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
Thank you.