Inventory Aging

[vasathi]

Dear Friends

I'm having an issue with Inventory aging calculations.

i have measure like, the result gives 0 or blank

Can some could you help me or find me wher i did wrong...

Thanks in advance

[v-yingjl]

Hi @vasathi ,

Not certain what is your sample table look like, basically the measure could return the calculated value.

In addition, how did you write [Total Qty] measure? Perhaps you can share more details about this issue or just modify the table structure based on the test sample.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@vasathi 

Not sure how your data model is setup and the measure is executed, can you try the following measure? Replace the line inside your Filter function here

Age 60-90 (qTY) = 

sumx ( 
    FILTER ( .... ),
    [Total Qtr]
)