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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AppleUSN
Frequent Visitor

Trying to build a Line of Balance/Stock Balance chart

I have a need to show the balance of quantity over a period of time based on supply and demand.  I am having trouble duplicating this and I cannot find a solution based on my question either so I am hoping the community can help me.  I want to calculate the running total of my stock level based on the demand date and the actual received date to show when I will be positive or negative on stock level.  I am trying to figure out how to calculate the position row below.  I can get the demand and commit qty no problem.  I can also show the difference between the two but I cannot figure out the difference with the running total.

 

4118215-01Past Due29-May5-Jun12-Jun19-Jun26-Jun3-Jul10-Jul17-Jul24-Jul
Demand Qty19154220000
Supplier Commit Qty 157100000
Position (19)(19)(16)(17)(19)(19)(19)(19)(19)

 

Feed Data

Part NumberQty OpenContract DateDock Date
4118215-0114/18/20234/18/2024
4118215-0114/19/20234/18/2024
4118215-0114/20/20234/18/2024
4118215-0114/24/20234/18/2024
4118215-0114/25/20234/18/2024
4118215-0114/27/20234/18/2024
4118215-0114/28/20234/18/2024
4118215-0115/3/20234/18/2024
4118215-0115/5/20234/18/2024
4118215-0115/8/20234/18/2024
4118215-0115/10/20234/18/2024
4118215-0115/12/20234/18/2024
4118215-0115/15/20234/18/2024
4118215-0115/16/20234/18/2024
4118215-0115/18/20234/18/2024
4118215-0115/22/20234/18/2024
4118215-0116/1/20234/18/2024
4118215-0116/5/20234/18/2024
4118215-0116/6/20234/18/2024
4118215-0116/7/20236/1/2023
4118215-0116/8/20236/5/2023
4118215-0116/9/20236/6/2023
4118215-0116/13/20236/7/2023
4118215-0116/13/20236/8/2023
4118215-0116/14/20236/9/2023
4118215-0116/16/20236/13/2023
4118215-0116/19/20236/13/2023
4118215-0116/20/20236/14/2023
4118215-0124/26/20236/16/2023
4118215-0116/27/20236/16/2023
4118215-0116/29/20236/16/2023
4118215-0114/26/20236/19/2023
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @AppleUSN,

Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:

Before You Post, Read This: start, end date 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
AppleUSN
Frequent Visitor

Hello Xiaoxin,

This did help me to find the solution.  I still had to dig deeper and create another measure to finish the formula but it did point me in the right direction.

 

Thanks again.

v-shex-msft
Community Support
Community Support

Hi @AppleUSN,

Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:

Before You Post, Read This: start, end date 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors