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

Hi Anonymous ,

I updated your sample pbix file(see attachment), please check whether that is what you want.

Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

 

thanks for your amazing support. This is very close to what I would like it to look like. However, this is now only counting the SUM(In/Out) for the IDs that appear twice. What I need is a formula, that only counts negative In/Out values (-1) if their ID has already appeared with a positive value (1). Positive values (1) should be counted regardles of whether they appear only once.

 

I tried to clarify it in the attached screenshot