Forum Discussion
DAX Calculate Inventory Expiry Risk
I've been searching a lot but can't seem to find an answer. I'll try to keep it brief, concise and complete. I work in a warehouse We store goods on locations Some of these goods have an expiry d...
PaulDBrown, unfortunately that's also incorrect.
Till 31 May = 169 days * 2.43 = 410 pcs of sales
I have 119 + 121 + 806 = 1046 - 410 = 636 pcs with exp risk and not 395.
You calculate it per line, but the calculations needs to take the results from all previous lines into account as well.
Hello, I am trying to do the same, just simple 1 location for now.
Inventory - expiry date, calculate what my risk is going to be, based on expected sales.
Did you ever get a solution for this ?