Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JakeandSnake
Frequent Visitor

Projection of the remaining aging inventory based on FIFO

Hi experts,

 

Need some help here...

 

Source:

I have two tables, one is Inventory Table, another one is Demand table. (As shown in the picture) 

1. Reach to WHS Date: the date when the inventory is in the warehouse.

2. Aging: Today's date - Reach to WHS Date

3. Request Date: the date when the demand can be deducted from inventory

 

Objective:

My objective is to show a projection for the next 12 months of remaining inventory, which aging more then 60 days. (Something like the bar chart here. For example, one part shows in bar Jun'24, it will keep showing on the following bar until the month no more inventory for this part. )

 

Conditions:

1. When calculating the remaing inventory for the particular part, need to follow the FIFO logic, the older inventory always need to be used out first. 

2. Able to see the part level details if I click the bar or drill thru it...

3. Both tables have almost 1 million rows.

 

I've stuck about one week, appreicated if anyone can help on this...

JakeandSnake_0-1719324107431.png

JakeandSnake_1-1719324121072.png

JakeandSnake_3-1719324773637.png

 

 

 

 

2 REPLIES 2
some_bih
Super User
Super User

Hi @JakeandSnake check link for FIFO inventory in Power BI as example





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

Proud to be a Super User!






Thanks @some_bih...I did see this blog, however my case have another complexity which is the projection of the remaining inventory...I still could not figured it out...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.