Calculation of inventory quantity

[Eiji77]

Item	2020/10/31	2020/11/1	2020/12/1
Sales		50	80
Purchase		70	40
Inventory	100	120	80

I would like to calculate the future inventory using the current month's inventory, future sales, and purchases.

(I want to calculate the part in red with DAX.)

I can use DAX's "CALCULATE" and "PREVIOUS MONTH" to calculate inventory for the next month. ([120] in the table)

However, I cannot calculate the inventory quantity for the following month. ([80] in the table)

How can I calculate the future inventory quantity?

This can be done in Excel, so I think it can be done in DAX.

I would be grateful if you could help me.

I'm Japanese, so I'm sorry that the English description is poor.

[wdx223_Daniel]

you can try CALCULATE and DATESINPERIOD functions.

[Eiji77]

Thank you , Daniel.

Please tell me a little more detail.

How should I use "DATESINPERIOD"?

Please tell me the description of DAX.

I'm trying while referring to the DAX reference, but it doesn't work.

I'm sorry to have you take the trouble.

[Anonymous]

https://dax.guide/datesinperiod/