cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 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

4 REPLIES 4
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Frequent Visitor

Thank you.

Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

@Greg_Deckler mm/dd/yyyy

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors