Forum Discussion

pawelj795's avatar
pawelj795
Post Prodigy
6 years ago

Inventory valuation - FIFO

Hi, 
I'm creating inventory valuation (FIFO) according to below article:
https://radacad.com/dax-inventory-or-stock-valuation-using-fifo#comment-304039

The mentioned columns: "Previous Cumulative Sale" and "Previous Cumulative buy" doesn't work when I had more than 1 sell/buy per day.
How to fix that?

I tried to add comment below article, but it's not possible ;(

Alternatively, if you have any better solution to calculate stock valuation with FIFO, don't hesitate to describe this.



Interesting Links
Need Help
Tips and Tricks

1 Reply

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    Hi pawelj795 ,

    What does "doesn't work" mean and what output you expect. Because both "Previous Cumulative Sale" and "Previous Cumulative buy" use the condition: "'Table1'[date] < myDate", you can adjust to "Table1'[date] <= myDate" if you want, if it is the same day, but you want to compare the size of the same day, you must have extra fields such as "time"/"index" to judge.

    I created a demo like the following, added an "index" column to judge, you can see if it is the result you want:

    Here is a demo, please try it:

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EVuRUC8Is2RLh9dNZE8nh14BZSMyAnVaJBwUngYjZO5l9A?e=h7dyst 

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.