Forum Discussion

aditya_141228's avatar
aditya_141228
Icon for Helper I rankHelper I
2 years ago
Solved

Inventory Aging Report

I'm stuch with this Inventory Aging report for more than a month, I've tried so many DAX expressions and what not. I'm sharing the link to the pbix file. Kindly look into it and help me out. T...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi aditya_141228 ,

     

    Based on your description, your matrix totals on page 2 are correct, then you can create a new measure.

    Measure = SUMX(VALUES('Aging Main'[Item Group]),[Aging > 180 Qty])

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi aditya_141228 ,

 

Based on your description, your matrix totals on page 2 are correct, then you can create a new measure.

Measure = SUMX(VALUES('Aging Main'[Item Group]),[Aging > 180 Qty])

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.