topic Re: Cumulative total within a column in DAX Commands and Tips

Cumulative total within a column

Anonymous — Fri, 19 Apr 2019 21:23:43 GMT

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 :

Regards !

Re: Cumulative total within a column

verscev — Tue, 23 Apr 2019 17:30:32 GMT

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

Re: Cumulative total within a column

Anonymous — Wed, 24 Apr 2019 15:45:40 GMT

Hi Evi,

it works perfectly, many thanks !

Yamin