Forum Discussion
Iamnvt
8 years agoContinued Contributor
Sales - stock Calculation
hi,
I have a Sales table:
Order Date Product Sales
| 1 | 11/25/2017 | A | 10 |
| 2 | 11/26/2017 | B | 20 |
| 3 | 11/27/2017 | A | 5 |
and a Stock table:
Product Quantity
| A | 1 |
| B | 2 |
How can I make a DAX measure to calculate the Material Requirement for each date?
Eg.
Date Product Requirement
| 11/25/2017 | A | 9 |
| 11/26/2017 | B | 18 |
| 11/27/2017 | A | 5 |
the tricky part is that the stock table does not have date column, meanwhile the Sales table has the Date column.
sample file is here:
https://1drv.ms/x/s!Aps8poidQa5zkvFwWm3YbzFb15bkTw
thanks