Forum Discussion

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

Calculation of inventory quantity

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 invento...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

you can try CALCULATE and DATESINPERIOD functions.

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.