Inventory valuation - FIFO

[pawelj795]

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.

[v-joesh-msft]

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

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.