Forum Discussion
calculate Monthly stock with missing values using future values
Hello comunity! I've been stucked on this for several weeks now! I'm creating a monthly report, the problem is that the logic of the ERP that we are using (SAP) to create the datasource is not tha...
Thanks for the quick response? Do you mean additional to the picture?
I'm not sure if I can upload files, but here are some examples of how the data appears:
| Plant | Material | Year | Month | Stock |
| G104 | 1000010691 | 2022 | 7 | 0 |
| G104 | 1000010691 | 2022 | 9 | 0 |
| G104 | 1000010691 | 2022 | 10 | 16 |
| G104 | 1000010691 | 2022 | 12 | 20 |
| G104 | 1000010691 | 2023 | 3 | 12 |
I need to be able to create a DAX that calculate the values and the table should look like this:
| Plant | Material | Year | Month | Stock |
| G104 | 1000010691 | 2022 | 7 | 0 |
| G104 | 1000010691 | 2022 | 8 | 0 |
| G104 | 1000010691 | 2022 | 9 | 0 |
| G104 | 1000010691 | 2022 | 10 | 16 |
| G104 | 1000010691 | 2022 | 11 | 20 |
| G104 | 1000010691 | 2022 | 12 | 20 |
| G104 | 1000010691 | 2023 | 1 | 12 |
| G104 | 1000010691 | 2023 | 2 | 12 |
| G104 | 1000010691 | 2023 | 3 | 12 |
Thanks for your help!
Ashish_Mathur
Super User
Super UserAwesome! It worked! Thank you very much you saved me!
- Ashish_Mathur
You are welcome.