Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Power Query Sumifs

‎06-01-2023 04:35 AM

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)

DimAt_0-1685619207072.png

Could you please help me? 🙂

Labels:
Message 1 of 3
795 Views
0
1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

‎06-01-2023 05:15 AM

pls try this

Power Query Sumifs.pbix

View solution in original post

Message 2 of 3
771 Views
2 REPLIES 2
Anonymous
Not applicable

‎06-01-2023 07:27 AM

Amazing, works! Thank you so much!!

Message 3 of 3
732 Views
0
Ahmedx
Super User
Super User

‎06-01-2023 05:15 AM

pls try this

Power Query Sumifs.pbix

Message 2 of 3
772 Views

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All