Power BI Formula Assistance Needed
Budget: $50 – $0 USD
I am currently working with operational data in Power BI and I need assistance with a specific formula. The primary aim of this formula is for calculation and aggregation. More specifically, I need help summing values.
You have a Beginning Inventory starting from April 2023.
Each month, you want to add incoming stock and subtract sales.
If the Ending Inventory for any month falls below zero, the Ending Inventory should be set to zero.
For the next month, the Beginning Inventory should reset based on what's coming in (incoming stock) for that month, and it continues adjusting accordingly.
You have a Beginning Inventory starting from April 2023.
Each month, you want to add incoming stock and subtract sales.
If the Ending Inventory for any month falls below zero, the Ending Inventory should be set to zero.
For the next month, the Beginning Inventory should reset based on what's coming in (incoming stock) for that month, and it continues adjusting accordingly.