Forum Discussion
Cumulative total within a column
Hi, I m trying to get the cumulative total within a column using earlier. But I want this cumulative total for each year and each company only (e.g. ADAPEI/SUDG) in the same column like this : ...
Hi Evi,
it works perfectly, many thanks !
Yamin
Hello Anonymous ,
You can do this by using the following function:
Cumulative =
VAR p_year = Table1[Year]
VAR p_month = Table1[Month]
VAR p_company = Table1[Company]
RETURN
SUMX (
FILTER (
Table1,
Table1[Year] = p_year
&& Table1[Month] <= p_month
&& Table1[Company] = p_company
),
Table1[Value]
)It groups first on the company, and will then sum the values with a yearmonth smaller or equal to the one in the current row.
I hope this will help.
Evi
Hi Evi,
it works perfectly, many thanks !
Yamin