topic Re: Calculation of inventory quantity in DAX Commands and Tips

Calculation of inventory quantity

Eiji77 — Tue, 27 Oct 2020 06:16:03 GMT

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 — Tue, 27 Oct 2020 06:40:41 GMT

you can try CALCULATE and DATESINPERIOD functions.

Eiji77 — Tue, 27 Oct 2020 07:26:45 GMT

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 — Tue, 27 Oct 2020 09:34:49 GMT