topic Add a static value to Calculated measure in Developer

Add a static value to Calculated measure

Sandhya877 — Tue, 09 May 2023 20:18:54 GMT

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

Re: Add a static value to Calculated measure

Greg_Deckler — Tue, 09 May 2023 21:11:00 GMT

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

Re: Add a static value to Calculated measure

Sandhya877 — Tue, 09 May 2023 21:57:53 GMT

@Greg_Deckler mm/dd/yyyy

Re: Add a static value to Calculated measure

Anonymous — Wed, 17 May 2023 07:05:10 GMT

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

Re: Add a static value to Calculated measure

Sandhya877 — Wed, 14 Jun 2023 13:43:36 GMT

Thank you.