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
6 years ago

hi depple,

 

can you give us the example where you use the filter?

 

i have also tried to do the same with calculate (distinctcount(field1),filter(allselected(table), [expirydate] >= [i still havent figured out what i should put in here]))