Doing Prediction Based on Simple Calculations

[NewNewNewbie]

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

[lbendlin]

Great that you already formulated the business rules. Now you can implement them directly.

Keep in mind that Power BI is a reporting tool, not a resource planning tool.