Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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 :

 

Cumulative.PNG

Regards !

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi Evi,

 

it works perfectly, many thanks !

 

Yamin

 

View solution in original post

2 REPLIES 2
verscev
Frequent Visitor

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

Anonymous
Not applicable

Hi Evi,

 

it works perfectly, many thanks !

 

Yamin

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.