Help with SUMIFS function

Question

Hey guys, is there an alternative function for SUMIFS in Power BI?&nbsp;&nbsp;Here is my formula and 2 tables in excel. I'm trying to calculate something similar in Power BI&nbsp;AP TableABCD189990011150020200004772020000331.12202000063.882020000270202000099.83521202040137.7189990020500140500026485Summary tableABCDEFGHIred&nbsp;1010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 6,861,730&nbsp;&nbsp;&nbsp; 6,861,730&nbsp;&gt;50000green1020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp; 6,861,730&nbsp;&nbsp;&nbsp; 6,861,730&nbsp;&gt;50000&nbsp;Formula&nbsp;=SUMIFS(AP!D: D,AP!B:B,Summary!B1,AP!C:C,Summary!C1,AP!A:A,Summary!I1)&nbsp;

v-yuta-msft · Answer

bouyazbekj,
&nbsp;
Not very understand what does the excel formula mean? Could you share some logic of how to generate the summary table for further analysis?
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Help with SUMIFS function

1 Reply

Related content

SumIf

SUMIF Function

Power Query Function (SUMIF)

sumif not working

SUMIF function

A	B	C	D
18999	0	0	111500
20200	0	0	477
20200	0	0	331.12
20200	0	0	63.88
20200	0	0	270
20200	0	0	99.83
52120	20	40	137.7
18999	0	0	20500
14050	0	0	26485

A	B	C	D	E	F	G	H	I
red	10	10	-	6,861,730		6,861,730		>50000
green	10	20	-	6,861,730		6,861,730		>50000