Forum Discussion
Track inventory level over time
Hi,
The data looks roughly as follows:
This graph should show that :
On 31.12.2020 we had a stock of 1 for Bikes and 1 for Cars.
On 1.1.2021 the stock increased to a total of 3 (2 Bikes, 1 Car)
On 15.1.2021 the stock increased to a total of 4 (3 Bikes, 1 Car)
On 16.1.2021 the stock increased to a total of 5 (3 Bikes, 2 Cars)
On 20.1.2021 the stock decreased to a total of 4 (2 Bikes, 2 Cars)
The layout of the data is clear to me so far. The problem starts between years. In this example, the stock on the 1.1.2021 always reads 1 Bike since the others where booked in the previous year. Any way to solve this issue? Can I create a "YTD" that starts on i.e. 1.1.2015 and counts until today?
Thanks in advance and best regards
Simon
Hi Anonymous ，
I have created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
Thanks a lot for your support! This has already worked out well!
I did however run into another issue:I need to take the ID into account. In my list there are a couple of machines that I have no "In" (positive value) for. They do however have an "Out" (negative value). Those are machines that were put into storage before the dataset. I would like to not take these into account. Thus only "Out" (-1) values for machines where there is an "In" value.
Can I work this out in Power BI somehow? I have the "In" and "Out" in seperate tables that are merged together.
Thanks and best regards!
Hi Anonymous ,
What do you mean that need to take ID into account? Could you please provide your sample pbix file(exclude sensitive data) and your expected result with example? Thank you. Do you still want to get the count of biks/cars?
Best Regards