Forum Discussion

aditya_141228's avatar
2 years ago
Solved

Need Help with Aging Report

I've been working on this Inventory Aging Report,  Here Base, Chemicals, Concentrate Chemicals are Item and every Item has multiple Products. The data that is coming here on Item Level for eac...
  • Ashish_Mathur's avatar
    2 years ago

    Hi,

    This measure will get the correct figure for Z_aging Qty < 30.  See the last column in the image

    Measure = SUMX(VALUES('Aging Main'[Product]),[Z_Aging Qty <30])

    Hope this helps.