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...

     

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    4 years ago

    egle_p I've had a monster bad week at work.  I apologize for not looking at this...will try to do so tomorrow 🙂

    • egle_p's avatar
      egle_p
      Frequent Visitor
      4 years ago

      littlemojopuppy Thank you for remembering 🙂

       

      I've figured most of it out - got too stuck on the filtered tables before. But one issue remains - rows with same arrival date need to be ordered by some other column as well (can't group them in the real data). Best would be to start from smallest quantity. I've given it a try and will continue to search in the original shared file.

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        4 years ago

        Hi egle_p 

         

        Sorry for the delay with this...I had a monster bad week at work.  😞

         

        I took your table and refactored it into a data model based around inventory transactions.  Here is a solution that doesn't involve calculated columns.  Overall, I think it's much simpler than what you had.

        Hope this helps!