Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Track inventory level over time

Hi,   I am currently working on a project where I want to show the inventory level of certain items on a timeline. For this I have two lists where on holds positive values for when an item is enter...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

The problem I am having is that I am trying to calculate the stock based on data starting on 1.12.2020. This means, that I do not know what machines entered the inventory prior to 1.12.2020.

 

In practice, this means that object A is leaving the inventory (-1) but on my list it has never entered the inventory (since I do not have data prior to the 1.12.2020). The inventory for this item is therefor -1 and not 0. 

 

To bypass this issue, I would like to only take those -1 values into account that already exists with a +1 value --> hence only calculate products leaving the inventory that I have registered entering the inventory. Since every booking has a unique ID, there might be a solution here.

 

I have tried to show this in the screenshot. The marked IDs have a negative value for [In/Out] but do not exist with a positive value. They should therefore not be counted in my inventory graph since they are "leaving the warehouse" but have never entered it according to my data. The graph shows the problem too. The inventory goes below zero since I am taking machines out of the warehouse but never documented them ever being in it.

 

Best regards

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am somehow not unabled to upload pbix files

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    You can upload your pbix file to OneDrive for Business, then share the file link with me. Please find the details in the following documentation.

    Share OneDrive files and folders

    Best Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      Also, is it possible to formulate the Measure differently, so that applied filters still work? I would like to be able to filter by user and other criterias.
       
      The formula I am refering to is this:
       
      Measure =
      CALCULATE (
      SUM ( 'Book'[In/Out] ),
      FILTER (
      ALLEXCEPT ( 'Book', 'Book'[Category] ),
      'Book'[Date] <= SELECTEDVALUE ( 'Date'[Date] )
      )
      )