Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.