Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Query Sumifs

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? 🙂