Forum Discussion

SharonCNE's avatar
SharonCNE
Frequent Visitor
6 years ago

Inventory at multiple locations and multiple dates

Hi everyone.  I have a list of inventory from multiple locations that was taken on different dates.  I need to know the current total inventory for each item using the last date posted from each loca...
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi SharonCNE ,

 

Try those measures:

 

_LastDate = CALCULATE(MAX('Table'[Date]); ALLEXCEPT('Table';'Table'[Item]))
 
Measure = CALCULATE(SUM('Table'[Quantity]); FILTER(ALLEXCEPT('Table'; 'Table'[Item]); 'Table'[Date] = [_LastDate]))
 
 
Did I answer your question? Mark my post as a solution!
Ricardo
  • SharonCNE's avatar
    SharonCNE
    Frequent Visitor
    6 years ago

    Ricardo thanks for answering so quickly - im getting this error

     

    The function SUM cannot work with values of type String

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      SharonCNE ,

       

      Be sure the quantity column is numeric.

       

      Did I answer your question? Mark my post as a solution!
      Ricardo

      • SharonCNE's avatar
        SharonCNE
        Frequent Visitor
        6 years ago

        Ricardo - yes value is a whole number :). the item is Text but I can't change that