cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jorgeeeh28 Frequent Visitor
Frequent Visitor

Sum by filter

Greetings I have 3 tables which have a material code in common one contains the initial stock for a certain month the other one contains requested material and the last one installed material i need to build up a balance of materials, in excel is easy solve this out with a sumifs. i need to summarized all the data of these three tables under this conditions: The date of the stock is strictly less than the date of requested materials and the date of the requested materials obviously less than the date of the installed materials. No idea how can i perform this issue cause i need to sum up and summarize all the data under the previous conditions. Any idea there?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Sum by filter

Hi @jorgeeeh28 ,

Could you please share some sample data and expected result to us for analysis?

Best Regards,

Teige

Highlighted
jorgeeeh28 Frequent Visitor
Frequent Visitor

Re: Sum by filter

sumarize.PNG

 

As you can see in the image above i created and ID which is the concatenate of the material code and sector, in column I is a given data of real stock for each material, column Q summarized the requisitioned material, and column R summarized the installed material. This a screenshot is  in excel. The given stock is in Excel the requisitioned data in SQL and the installed data in SQL though colums Q and R are the expected solution (In this case i used sumifs), which have the conditions: For requisitoned materials its date must be strictly greater than the date of the given stock. For installed materials its date must be strictly treater than the date of requisitoned materials. These are three different tables on power bi with a same common material code but i need to compare dates to add up everything.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 179 members 1,741 guests
Please welcome our newest community members: