Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PP_Freshman
New Member

[Question] How to replicate Excel SUMIFS Function?

Summary

Table 1 (2400+ rows) in Power Query Editor contains the below data:

  • Type
  • Category (e.g. Accessory, Technology)
  • Sub-Category (e.g. Laptop, Mobile Phone)
  • Purchase - Year
  • Delivered? (e.g. No, Yes).

 

Output in Power Query Editor

  • Create a new Table (connected to Table 1).

Replicate SUMIFS Function (i.e. from Excel) to:

  • Create two Columns
    • Total Sales (£)
    • Total Quantity of Sales
  • SUMIFS based on Table 1. For example:
    • Where Type = "A"
    • AND Category = "Technology"
    • AND Sub-Category = "Laptop"
    • AND Purchase - Year = "2023"
    • AND Delivered = "Yes"

Example of Desired Result

Desired_Result.PNG

 

 

 

 

 

 

Thank you!

 

1 REPLY 1
Ahmedx
Super User
Super User

could you share your pbix-file? Or create an example file which reproduces your issue?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.