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.
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 |
Solved! Go to 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] )
is your excel formula correct? one pair of criteria and range are date. You don't have the same date in both tables.
Proud to be a Super User!
@may-natta , a new column in sheet1
sumx(filter(sheet2, sheet1[A] =sheet2[A] && sheet1[B] =sheet2[B] && sheet1[C] =sheet2[C]), sheet2[F] )
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |