Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to replicate sumifs in power query (and not DAX). I know I can use group by, but one of the criteria is <= insetad of =.
Here is an example in excel:
=SUMIFS(B:B;D:D;D2;C:C;C2;E:E;"<="&E2)
Could you please help me? 🙂
Solved! Go to Solution.
Amazing, works! Thank you so much!!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |