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

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

The result I'm looking for is

do you have an idea if that is doable ?

Thank you so much for the support

2 ACCEPTED SOLUTIONS
Super User

Hi, @HE

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])))

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.

Community Champion

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] )
)``````

2 REPLIES 2
Community Champion

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] )
)``````

Super User

Hi, @HE

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])))

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.

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.