Skip to main content
cancel
Showing results for 
Search instead 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

Reply
HE
Frequent Visitor

Increment values by row in a table

Hello, 

 

I need your help if someone knows how to do this please, I have a table with values and I want to increment values by row.

HE_0-1616676063254.png

The result I'm looking for is 

HE_1-1616676355330.png

do you have an idea if that is doable ? 

 

Thank you so much for the support 

 

2 ACCEPTED SOLUTIONS
Jihwan_Kim
Super User
Super User

Hi, @HE 

please try the below.

By the way, the table name that I assigned is Data.

 

Cumulate Total =
CALCULATE( SUM(Data[Value]), FILTER( ALLSELECTED( Data[Index]), Data[Index] <= MAX(Data[Index])))
 
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!!

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


View solution in original post

themistoklis
Community Champion
Community Champion

@HE 

 

Try any of the following 2:

 

 

Running Total Measure = 
CALCULATE (
    SUM ( Table[Value] ),
    FILTER( ALL (Table ),
    Table[Index] <= MAX( Table[Index] ))
)

 

 

 

Running Total COLUMN =
CALCULATE (
    SUM ( 'Table'[Values] ),
    ALL ( 'Table' ),
    'Table'[Index] <= EARLIER ( 'Table'[Index] )
)

 

 

 

 

 

View solution in original post

2 REPLIES 2
themistoklis
Community Champion
Community Champion

@HE 

 

Try any of the following 2:

 

 

Running Total Measure = 
CALCULATE (
    SUM ( Table[Value] ),
    FILTER( ALL (Table ),
    Table[Index] <= MAX( Table[Index] ))
)

 

 

 

Running Total COLUMN =
CALCULATE (
    SUM ( 'Table'[Values] ),
    ALL ( 'Table' ),
    'Table'[Index] <= EARLIER ( 'Table'[Index] )
)

 

 

 

 

 

Jihwan_Kim
Super User
Super User

Hi, @HE 

please try the below.

By the way, the table name that I assigned is Data.

 

Cumulate Total =
CALCULATE( SUM(Data[Value]), FILTER( ALLSELECTED( Data[Index]), Data[Index] <= MAX(Data[Index])))
 
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!!

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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