Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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...
Need Help
Nhk22's avatar
Nhk22
Regular Visitor
3 years ago

Hi Anonymous  had u found the solution? I have to built similar to count stock on hand quantity backwards based on FIFO receipts transactions. 1st table show SOH qty for the month, and 2nd table have receipts date and quantity for the material item at company level.  How should I connect these two tables? Thanks for the team advise. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Share some data, explain the question and show the expected result.

    • Nhk22's avatar
      Nhk22
      Regular Visitor
      3 years ago

      1st table : stock on hand position

      Company CodePlantMaterialSOH QuantityStock on Hand per PlantFIFO Quantity
      FR0290601000640131,349.000852.000220.421
      FR0290411000640131,349.000497.000128.579

       

      2nd table: receipt transactions with aging bracket

      Company CodePlantMaterialAgeRcpt Dateobs range & % Receipt Quantity
      FR029060100064013630-Nov-220 to 11 month  0 %1000
      FR0290411000640132120-Aug-2112 to 23 mths 25%525
      FR0290411000640135130-Jul-21> 24 months 50%1990
      FR02904110006401311130-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 dateReceipt QtyReceipt  ageing bracket
       1000 Jun-2110000%
      balancing figure349 Aug-2052525%
      SOH Quantity :1349    
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        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.