Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
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.
@Sandhya877 What's your date format? mm/dd/yyyy or dd/mm/yyyy?