Forum Discussion
Cumulative Value by Category
I have this Table and i want to create a "Cumulative Value" Column, How can i do this in DAX as neu Column ?
I have write this Code:
Cumulative Value =
SUMX ( FILTER
( Table_name, EARLIER ( Table_name [Id] ) = Table_name [Id]
&& EARLIER ( Table_name [Category] ) = Table_name [Category] ),
Table_name [Value] )
With this code I get other values as in the picture.
2 Replies
- amitchandak
Super User
Aladin66 ,
Actually you need an index column for that
otherwise
Cumulative Value =
SUMX ( FILTER
( Table_name, EARLIER ( Table_name [Id] ) = Table_name [Id]
&& EARLIER ( Table_name [Category] ) = Table_name [Category]
&& Table_name [Value] =EARLIER ( Table_name [Value] )
),
Table_name [Value] )
with index column
Cumulative Value =
SUMX ( FILTER
( Table_name, EARLIER ( Table_name [Id] ) = Table_name [Id]
&& EARLIER ( Table_name [Category] ) = Table_name [Category]
&& Table_name [index] =EARLIER ( Table_name [index] )
),
Table_name [Value] )
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
I have index column created but this not working. i want a specific index how can i make that?
