Forum Discussion
DAX Formula: Inventory QOH in reverse
Disclaimer: I just started working with DAX and I've read and watched a ton of content but I'm still getting hung up on very simple problems. I learn faster if I can see the solutions to the problem...
Ashish_Mathur
Super User
Super UserHi,
Share some data, explain the question and show the expected result.
1st table : stock on hand position
| Company Code | Plant | Material | SOH Quantity | Stock on Hand per Plant | FIFO Quantity |
| FR02 | 9060 | 100064013 | 1,349.000 | 852.000 | 220.421 |
| FR02 | 9041 | 100064013 | 1,349.000 | 497.000 | 128.579 |
2nd table: receipt transactions with aging bracket
| Company Code | Plant | Material | Age | Rcpt Date | obs range & % | Receipt Quantity |
| FR02 | 9060 | 100064013 | 6 | 30-Nov-22 | 0 to 11 month 0 % | 1000 |
| FR02 | 9041 | 100064013 | 21 | 20-Aug-21 | 12 to 23 mths 25% | 525 |
| FR02 | 9041 | 100064013 | 51 | 30-Jul-21 | > 24 months 50% | 1990 |
| FR02 | 9041 | 100064013 | 111 | 30-May-21 | > 24 months 50% | 2000 |
output expected: Obsolescene is Calculated at Company Code Level based on FIFO Aging Methodology. To compute SOH backward based on latest FIFO receipt tranactions that made up the ending SOH.
| Source: | 3. obs receipt aging extract (show applicable only) | ||||
| SOH Quantity 2 | Last receipt date | Receipt Qty | Receipt ageing bracket | ||
| 1000 | Jun-21 | 1000 | 0% | ||
| balancing figure | 349 | Aug-20 | 525 | 25% | |
| SOH Quantity : | 1349 |
- Ashish_Mathur
Hi,
I cannot undestand from the 2 tables that you have pasted. Would it be possible to put this data in an MS Excel workbook and explain the result with formulas/text boxes.
I still do not know how much i can help but i would like to try.