Power Query Sumifs

[Anonymous]

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

[Anonymous]

Amazing, works! Thank you so much!!

[Ahmedx · Accepted solution]

pls try this

Power Query Sumifs.pbix