Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 !
Solved! Go to Solution.
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
19 | |
11 | |
10 | |
8 | |
8 |
User | Count |
---|---|
20 | |
13 | |
8 | |
7 | |
6 |