Hello, I have several tables with structure like this:
1. Stock Table, with column:
a. Material (with several unique materials)
b. Period (only have 1 date, for example 1 Nov 2023)
c. Qty
2. Sales Plan, with column:
a. Material (with several unique materials)
b. Periode (with many date aggregated in start of month, for example 1 Nov 2023, 1 Dec 2023, 1 Jan 2024, etc)
c. Qty
3. Supply Plan, with column:
a. Material (with several unique materials)
b. Periode (with many date aggregated in start of month, for example 1 Nov 2023, 1 Dec 2023, 1 Jan 2024, etc)
c. Qty
what I want is, first, create Salesplan Readiness, by doing some IF formula, IF Sales Plan[Qty] <= Stock[Qty], then Sales Plan[Qty], Else Stock[Qty], I have created this measure
and then I want to predict next month Stock by using formula: Stock Table[Qty] + Supply Plan[Qty] - Salesplan Readiness.
How to create a measure that predict next month stock? Thank you
