Forum Discussion
SumIfs function in power query
Hi Anonymous,
Thank you for reaching out to the Microsoft fabric community forum. Thank you bhanu_gautam for your input on this issue.
It looks like your issue is related to an Excel query, and for the best possible support on this, I would recommend posting your question in the Excel Community. The community there is specifically focused on Excel related issues, and you'll likely get the most accurate solution for your needs.You can find the Excel Community here: Microsoft Excel Community
Just to clarify, the Microsoft Fabric Community focuses on issues related to Power BI and Microsoft Fabric, so the Excel Community will be the best place for your specific query.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.Thank you for using Microsoft Community Forum.
Anonymous
Load Data into Power Query
Go to the Data tab in Excel and select Get Data > From Other Sources > From Table/Range.
Load both the SCRAP and Nonpr scrap sheets.
Merge Queries
In Power Query, select the SCRAP query.
Go to the Home tab and select Merge Queries.
Choose the Nonpr scrap query to merge with.
Select the columns to merge on (e.g., Account alias and Item).
Filter by Date
Add a custom column to filter the data based on the date in Nonpr scrap!$D$1.
Go to the Add Column tab and select Custom Column.
Use the following formula to filter by date:
powerquery
if [Date] <= Date.FromText("02/25/2025") then [Value] else null
Replace "02/25/2025" with the reference to the date column from Nonpr scrap.