Forum Discussion

egle_p's avatar
egle_p
Frequent Visitor
4 years ago
Solved

DAX for FIFO quantities

Hello! I've been down this FIFO rabbit hole before so thought better turn to experts.    Need to tweak the very helpful inventory valuation logic https://radacad.com/dax-inventory-or-stock-valuatio...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi egle_p 

    Somewhere in my head, looking at the data you provided, I thought you were going for LIFO, despite you clearly saying FIFO.  My apologies...  ğŸ˜•

     

    This is what you were after...

     

egle_p's avatar
egle_p
Frequent Visitor
4 years ago

Hi! littlemojopuppy sorry - as the link included a pbi file, I got careless 🙂

 

My work is here https://1drv.ms/u/s!Ak-sMmW0cEa0g7hq8SYtWGVvwceDGQ?e=A0ooSi 

 

It includes a column of expected results (sold quantities in the order of last arrival in stock, by SKU and stock location), 4 calculated cumulative columns that look correct and the final FIFO sold calculation that I'm unable to wrap my head around..

 

There will always be one sale row per SKU per location, so the previous cumulative sell is constantly 0 but I expect I can change that for better efficiency myself.