Forum Discussion

Eiji77's avatar
Eiji77
Icon for Helper II rankHelper II
5 years ago

Calculation of inventory quantity

Item2020/10/312020/11/12020/12/1
Sales　5080
Purchase　7040
Inventory10012080

 

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.

3 Replies

    • Eiji77's avatar
      Eiji77
      Icon for Helper II rankHelper II
      5 years ago

      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.