Forum Discussion

depple's avatar
depple
Icon for Helper III rankHelper III
7 years ago
Solved

Inventory calculation - Based on expiry date

Hi,   I am trying to create a weekly inventory report, but I am having difficulties creating a measure that adjusts inventory for expiry date. Below are two example tables that show my structure. ...
Need Help
  • depple's avatar
    depple
    7 years ago

    I found a solution using the CALCULATE function, with expiry date as filter.

     

    Thanks to all that took their time to read my issue.

     

    /depple

depple's avatar
depple
Icon for Helper III rankHelper III
7 years ago

I found a solution using the CALCULATE function, with expiry date as filter.

 

Thanks to all that took their time to read my issue.

 

/depple

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello depple,

 

Trust you are great. Please can you help share the DAX measure you used to solve this problem? I have a similar issue I am currently on.

 

I want to show the cumulative inventory level considering the future expiry dates.

 

Thanks

deji