Thank this author by sharing:
By Jacob Sebastian,
TSQL Challenge 74 - Find the expiring quantity of material
The challenge is to create a query for a report that show expiring material. There is a table with material that have a expiry date. Another table holds request for the expiring material. You need to show how much material will be expiring that do not have request in queue for.
Provide material for 70-448
Need SSAS Materials link