Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 @YaminK ,
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.