Forum Discussion
Sum/ Max - Calculation based on date [Stock calculation]
Hello all, I am totaly new one with PowerBi DAX function. I already have it one post ( solved ) but now need the upgrade the function but dont know how to achiev. All the Dates values are in fo...
What's the point of computing Total Stock? Stock is something that only has a meaning for each individual day.
How can Balance Stock be negative? Are you selling things that are not there?
In this case, the measure for "total stock" is just there so I can subtract it along with "Total Demand"
This works fine, I need even negative values to know when the material will run out and on what day, the problem is with the calculation I think with "Total demand" when it calculates the first day where it found the value in the demand column. But I would need this to only start calculating for the current week and onwards.