Sum by filter

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.