SUMIFS on Excel in DAX Power BI

[may-natta]

Please help me,

in Excel =SUMIFS('Sheet2!F:F,'Sheet2'!A:A,A2,'Sheet2,C2,'Sheet2'!D:D,D:D)

i don't know DAX in Power BI

Sheet 1

A	B	C	D	E
2021-08-01	B2	C2	D2	1 (=SUMIFS('Sheet2!F:F,'Sheet2'!A:A,A2,'Sheet2'!C:C,C2,'Sheet2'!D:D,D:D))
2021-08-01	B3	C3	D2
2021-08-01	B4	C4	D3
2021-08-01	B4	C4	D4

Sheet 2

A	B	C	D	E	F
2021-08-03	B2	C2	D2	E2	1
2021-08-03	B3	C3	D2	E4	1
2021-08-04	B4	C4	D3	E6	50
2021-08-04	B4	C4	D4	E3	5

[ryan_mayu]

@may-natta 

is your excel formula correct? one pair of criteria and range are date. You don't have the same date in both tables.

[amitchandak · Accepted solution]

@may-natta , a new column in sheet1

sumx(filter(sheet2, sheet1[A] =sheet2[A] && sheet1[B] =sheet2[B] && sheet1[C] =sheet2[C]), sheet2[F] )