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 ( Ta...
amitchandak
Super User
Super UserAladin66 ,
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?