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 Cumulativ...
Interesting Links
Need Help
Tips and Tricks
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.