SUMIF with PowerPivot

kuba1989

New Member
Joined
Jul 16, 2014
Messages
1
Dear All,


I have a problem. I need to use SUMIF'ish function in PowerPivot that would go something like this.


A 1
B 2
C 3
A 10
A 50
B 60
B 10

And for this Data I would like to get

A 61
B 72
C 3
A 61
A 61
B 72
B 72

So it would be a sumif with changing criteria for each row. How to solve this? Thanks guys !
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
The first formula will give better performance if you have a big data set

1. CALCULATE(SUM([Sales]),ALLEXCEPT(Table1,Table1[item]))

2. SUMX(FILTER(Table1,Table1[item]=EARLIER(Table1[item])),[Sales])









 
Upvote 0
The first formula will give better performance if you have a big data set

1. CALCULATE(SUM([Sales]),ALLEXCEPT(Table1,Table1[item]))

2. SUMX(FILTER(Table1,Table1[item]=EARLIER(Table1[item])),[Sales])










Dear Bob,

Could you help me with the below ?

In my case i would like to calculate cumulative totals for data containing GL Account Balances (Column 1) for each of the Financial period (Column 2) having the "Current period activity (Column 3).

I would like to perform the below

Account | Period | Amount | Cumulative
A100 1 100 100
A100 2 200 300

So i want to calculate the cumulative column in Power Pivot, also would be helpful if the same could be done using Power Query.

Thanks in advance.
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,923
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top