Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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:
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |