Forum Discussion

Funk-E-Guy's avatar
Funk-E-Guy
Icon for Helper II rankHelper II
4 years ago

Avoiding Circular Discrepancies for Col A = Col B (last row) and Col B = Col A (current row)?

My goal: To use DAX to calculate Ending Inventory as a function of MAX(0, Beginning Inventory + Receipts - Forecast), for every day and every SKU.   My Issue: I do not know how to lookup the previo...