Hello,
I'm new to Power BI, and I'd like to consult a problem I haven't been able to solve.
As you can see in the image below, I have columns for each month, such as demand, production, transfer, and starting inventory.
I want to calculate opening inventory and closing inventory for each month. However, it's crucial that my inventory never goes negative at the closing. In cases where it goes negative, I also want it to be recorded as 'out of stock.' I've tried various approaches and looked at all the suggested solutions, but I couldn't find a suitable solution. Can you help?
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
