Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |